Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MsgBox Modality

Status
Not open for further replies.
gayd

gayd

Technical User
Nov 28, 2002
1
US
Is it possible to modify the modality of a MsgBox in a VBA script? Thanks for any suggestions
 
Sort by date Sort by votes
Not without extensive trickery. I think it would be easier to use a userform.
Rob
[flowerface]
 
Upvote 0 Downvote
Yup - someone on the excel L list posted some code to do funky things with msgbox modality but it was a set of API calls and was about 200 or so lines just to do a coupla simple things.

Definately go with the userform idea Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

fireeee
  • Locked
  • Question
simple script that asks for a password with inputbox/msgbox/net use
Replies
1
Views
67
SkipVought
S
davedave24
  • Locked
  • Question
Importing sheet from another WB, without triggering wb_open msgbox
Replies
4
Views
99
SkipVought
S
wmbb
  • Locked
  • Question
Long path in msgbox
Replies
5
Views
79
wmbb
wmbb
PWD
  • Locked
  • Question
MsgBox suppression Excel 2010 2
Replies
3
Views
49
PWD
PWD
Ifutant
  • Locked
  • Question
Outlook VBA Insert Subject Line Based on MsgBox Response 1
Replies
13
Views
165
Ifutant
Ifutant

Part and Inventory Search

Sponsor

Back
Top