I.T. Discussion Community!
-Collapse +Expand
VB Classic
Search VB Classic Group:

Advanced
-Collapse +Expand VB Classic Store

Prestwood eMagazine

June Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyVisual Basic Classic BoardVB Classic Control Usage and Developing Topic   Print This     

MsgBox

thecrazedmonster
-- USA
I am in need of some help with the MsgBox. At work we use Excel and I have a button that will clear certain Cells when you click on it, after you click on the button the MsgBox popsup and ask if your sure, I cannot get the "No" button to work. If you need more info plz e-mail me:

[EMAIL]thecrazedmonster@yahoo.com[/EMAIL] Confused
 Posted 17 years ago (Thread Starter)
Comment Quote
About thecrazedmonster -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #6100, 3 replies
Thread Started 5/4/2002 2:56:00 AM
View Counter=3136
Last Reply Posted 5/6/2003 11:10:00 PM)
Location=-- USA 
Joined=17 years ago   MB Posts=1  
RobZ
 (Inactive)
JHB, South Africa
Try this,
Function/Sub DelCels()
ans = msgbox("Are You Sure?",vbQuestion+VbYesNo)
if ans = vbYes then
'Delete Cells here
end if
end Function/Sub
hope this helps
 Posted 17 years ago
Comment Quote
About RobZ -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #7884 (Level 1.1)  Reply to 6100
Thread Started 10/11/2002 1:11:00 AM
View Counter=2
Location=JHB, South Africa  
Joined=18 years ago   MB Posts=9  
Daniel Fought
Prestwood IT
Home office in Fresno, CA.
one line of code is worth a thousand questions. How about showing us what you are attempting to do that isn't working?

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions
http://www.prestwood.com

 Posted 17 years ago
Comment Quote
About Daniel Fought -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Daniel Fought
Danial Fought is a senior programmer analyst with Prestwood IT where he develops custom Windows software and custom websites. When Dan is not coding for clients, he participates in this online community. Coding specialties include Paradox/ObjectPAL, MS Access, Visual Basic, and VS.Net/VB.Net.

Post ID #6398 (Level 1.2)  Reply to 6100
Reply Posted 5/31/2002 9:16:00 AM
Location=Home office in Fresno, CA. 
Joined=17 years ago   MB Posts=401   KB Posts=12   KB Comments=4  
Most Recent Post
Dante
 (Inactive)
South - Africa
Fisrt of is the ans variable declared as a integer, if so try this code, it just might work.

if msgbox("Are You Sure?",vbQuestion+VbYesNo) = vbYes then

delete cells

end if

Or maybe you can set the buttons to vbOkCancel and then try to use the vbCancel = true statement in your if statement. Geek Alert!
 Posted 16 years ago
Comment Quote
About Dante -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #9549 (Level 1.3)  Reply to 6100
Reply Posted 5/6/2003 11:10:00 PM
Location=South - Africa  
Joined=16 years ago   MB Posts=17  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1264A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #6100 Counter
3136
Since 4/2/2008
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech