morteza2006
12-03-2012, 03:41 AM
Hi all
I need help
I have a userform and a command button
I want cell a1 on sheet 1 in any order that I open the userform and press the command button to run the command
Example
If I wrote the following formula in cell a1
sub commandbutton1_click ()
msgbox "aaa"
end sub
After opening the userform and clicks the commandbutton to run this command.
And if I have the following formula in cell a1
sub commandbutton1_click ()
userform1.height = 100
end sub
After opening the userform and clicks the commandbutton to run this command.
Thank you
I need help
I have a userform and a command button
I want cell a1 on sheet 1 in any order that I open the userform and press the command button to run the command
Example
If I wrote the following formula in cell a1
sub commandbutton1_click ()
msgbox "aaa"
end sub
After opening the userform and clicks the commandbutton to run this command.
And if I have the following formula in cell a1
sub commandbutton1_click ()
userform1.height = 100
end sub
After opening the userform and clicks the commandbutton to run this command.
Thank you