LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 57
Default Multiple VByesno Message boxes no working

When my 1st message box appears & user click "yes" macro does what it
supposed to do. If user clicks "no", I want another message box to appear
with a "yes/no" option, but I can't figure out how to get the second message
box to appear correctly. I don't know what I'm doing wrong & appreciate any
help!

Dim Msg, Style, Title, Help, Ctxt, Response, MyString
Msg = "Do you want to add another employee?"
Style = vbYesNo
Title = "DAC Sheet Updated"
Response = MsgBox(Msg, Style, Title, Help, Ctxt)

If Response = vbYes Then
Sheets("Sheet1").Select
Range("E4").Select


Else
MyString = "No"
Msg , Style, Title, Help, Ctxt, Response, MyString
Msg = "Are you done?"
Style = vbYesNo
Title = "DAC Sheet Updated"
If Response = vbYes Then
Cells.Select
Selection.Copy
MsgBox ("New info is copied in the clipboard.")
Else: Sheets("Sheet1").Select
End If


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple message boxes, one after the other in AutoOpen or other? StargateFan Excel Programming 3 August 4th 09 06:20 AM
Message Boxes VoxBox-Richard Excel Programming 2 August 5th 08 10:32 PM
Multiple Lines in Message Boxes NickHK Excel Programming 0 November 15th 06 02:20 AM
vbYesNo message box Big Mac Excel Programming 5 May 9th 06 02:42 PM
Displaying Multiple values with message boxes Dani Excel Programming 1 January 10th 06 11:41 PM


All times are GMT +1. The time now is 07:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"