| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy VBA Syntax Question
I have a macro that pauses for a user response. A dialog box comes u saying "The selection contains multiple data values. Merging into on cell will keep the upper-left most data only." At this point, I can hi OK and it will continue. How can I automate this so it automatically selects OK? Thank you -- Hul ----------------------------------------------------------------------- Hulk's Profile: http://www.excelforum.com/member.php...fo&userid=1494 View this thread: http://www.excelforum.com/showthread.php?threadid=26895 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Easy VBA Syntax Question
Place the following around your code that does the merge: Application.DisplayAlerts = False 'Your Code Application.DisplayAlerts = True -- kkkni ----------------------------------------------------------------------- kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754 View this thread: http://www.excelforum.com/showthread.php?threadid=26895 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Easy VBA Syntax Question
I think this is how it works...
MsgBox "This is default button",vbYesNo + vbDefaultButton2,"Try It N See" vbDefaultButton2 designates the second button (NO) as the default button. doco "Hulk" wrote in message ... I have a macro that pauses for a user response. A dialog box comes up saying "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only." At this point, I can hit OK and it will continue. How can I automate this so it automatically selects OK? Thank you! -- Hulk ------------------------------------------------------------------------ Hulk's Profile: http://www.excelforum.com/member.php...o&userid=14947 View this thread: http://www.excelforum.com/showthread...hreadid=268956 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Easy VBA Syntax Question
oops! Misunderstood the question ... sorry.
"Don Cossitt" wrote in message ... I think this is how it works... MsgBox "This is default button",vbYesNo + vbDefaultButton2,"Try It N See" vbDefaultButton2 designates the second button (NO) as the default button. doco "Hulk" wrote in message ... I have a macro that pauses for a user response. A dialog box comes up saying "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only." At this point, I can hit OK and it will continue. How can I automate this so it automatically selects OK? Thank you! -- Hulk ------------------------------------------------------------------------ Hulk's Profile: http://www.excelforum.com/member.php...o&userid=14947 View this thread: http://www.excelforum.com/showthread...hreadid=268956 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Easy VBA Syntax Question
If you want it to automatically select OK, why have the dialog box at all?
-- HTH RP "Hulk" wrote in message ... I have a macro that pauses for a user response. A dialog box comes up saying "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only." At this point, I can hit OK and it will continue. How can I automate this so it automatically selects OK? Thank you! -- Hulk ------------------------------------------------------------------------ Hulk's Profile: http://www.excelforum.com/member.php...o&userid=14947 View this thread: http://www.excelforum.com/showthread...hreadid=268956 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Syntax question | Excel Worksheet Functions | |||
| VBA syntax question | Excel Discussion (Misc queries) | |||
| syntax question | Excel Worksheet Functions | |||
| new user with easy question? not easy for me | New Users to Excel | |||
| Syntax question | Excel Programming | |||
![Hulk[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
