ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pop-Up Windows (https://www.excelbanter.com/excel-programming/335819-pop-up-windows.html)

Bigk

Pop-Up Windows
 
How do I put up a pop-up window from a macro module that has text I
define which forces the user to press OK after reading it? Thanks.

*** Sent via Developersdex http://www.developersdex.com ***

Tom Ogilvy

Pop-Up Windows
 
msgbox "Here is the message",vbOK

--
Regards,
Tom Ogilvy



"Bigk" wrote in message
...
How do I put up a pop-up window from a macro module that has text I
define which forces the user to press OK after reading it? Thanks.

*** Sent via Developersdex http://www.developersdex.com ***




Judd Jones[_2_]

Pop-Up Windows
 
The following works for entering a value in the activecell.

ActiveCell = Application.InputBox( prompt:="text", Title:="Title",
Default:=0, Left:=20, Top:=20, Type:=1)


"Bigk" wrote:

How do I put up a pop-up window from a macro module that has text I
define which forces the user to press OK after reading it? Thanks.

*** Sent via Developersdex http://www.developersdex.com ***



All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com