Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another approach - Program Command Button
Hello World!!! Is their a code for a command button, in a user form, that will put certain value in a cell when pushed. I want to create a userform with command buttons. If I push one o these buttons, I want that button to put, lets say a number 7 in cel D4; so on, so on. Is this possible? How? Thanks, EMo -- EMo ----------------------------------------------------------------------- EMoe's Profile: http://www.excelforum.com/member.php...fo&userid=2318 View this thread: http://www.excelforum.com/showthread.php?threadid=47240 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another approach - Program Command Button
in the vbe, place you command button and then double click on it.
This will put the Click event declaration in the Userform Module Private Sub CommandButton1_Click() End Sub then just put your code in there Private Sub CommandButton1_Click() Worksheets("Sheet1").Range("D4").Value = 7 End Sub -- Regards, Tom Ogilvy "EMoe" wrote in message ... Hello World!!! Is their a code for a command button, in a user form, that will put a certain value in a cell when pushed. I want to create a userform with command buttons. If I push one of these buttons, I want that button to put, lets say a number 7 in cell D4; so on, so on. Is this possible? How? Thanks, EMoe -- EMoe ------------------------------------------------------------------------ EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183 View this thread: http://www.excelforum.com/showthread...hreadid=472407 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another approach - Program Command Button
Hello! I was wondering how to call up the "save as" box with code (as if yo went to File and selected Save As...). I tried through the macr recorder, but it wouldn't let me stop recording when the box was open. Thanks, M -- EMo ----------------------------------------------------------------------- EMoe's Profile: http://www.excelforum.com/member.php...fo&userid=2318 View this thread: http://www.excelforum.com/showthread.php?threadid=47240 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem sending the command to the program | Excel Discussion (Misc queries) | |||
running a command button from a program | Excel Programming | |||
Shell Command to initiate Linux program | Excel Programming | |||
starting an external program with a command line | Excel Programming | |||
starting an external program with a command line | Excel Programming |