Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default How to: Assign pop up when command button is pushed

Hello,

Does anyone know how to assign a pop up message when a command button is
pushed? I'm trying to create a form that has help buttons and when one of
the help buttons is pushed by a user I need a pop up (or something like it)
to come up and say a specific message.

Please help. Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 276
Default How to: Assign pop up when command button is pushed

sub msg()
msgbox "This is the message",, "Title Box" ' <====== Modify to suit
end sub

You can use the :
call msg to run the msgbox


Or alternately

in design mode double click the command button you want to run the message,
then place the code there.

Corey....

"Sara Stone" wrote in message
...
Hello,

Does anyone know how to assign a pop up message when a command button is
pushed? I'm trying to create a form that has help buttons and when one of
the help buttons is pushed by a user I need a pop up (or something like
it)
to come up and say a specific message.

Please help. Thanks!



Reply
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
Assign a function to a Command Button MUEEN SEHDI[_2_] Excel Worksheet Functions 3 November 1st 09 01:58 PM
how can I assign a password to a command button Help! Excel Programming 2 January 4th 06 01:52 PM
Assign a macro to a command button Tom E Excel Programming 3 July 8th 05 08:31 PM
command button and assign macro Dave Peterson[_3_] Excel Programming 2 May 27th 04 03:01 AM
Returning last button pushed in Excel 7 sth Excel Programming 2 April 9th 04 01:36 PM


All times are GMT +1. The time now is 10: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"