View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
AJO[_3_] AJO[_3_] is offline
external usenet poster
 
Posts: 1
Default Three userform questions


I have a quick question about this alternative. You say go to the Forms
toolbar and select Button control. Where exactly is the Forms toolbar?
I can't seem to figure out what you're referring to.

Thanks


Toppers Wrote:
Chris,
Some alternatives to Bob's solutions:

(1) Use a button instead of a cell and call macro e.g.

Sub DisplayForm()
UserForm1.Show
End Sub

Go to FORMS toolbar, select Button control and then "Assign Macro"; in
my
example "DisplayForm"



--
AJO
------------------------------------------------------------------------
AJO's Profile: http://www.excelforum.com/member.php...o&userid=31286
View this thread: http://www.excelforum.com/showthread...hreadid=503758