button to activate userform

[Virginia]

What code would I use to call up a userform via a toolbar
button? The userform is not part of a macro, and I'm not
sure how to make it one. Does it need to be a dialogue
box? Also, is it possible to have the date already
filled in?

Is there a way to have a combo box reference an index
list on a existing worksheet? Ideally, any unrecognised
entries to the userform would then be added to the index,
and any recognised entries would fill in the address and
phone on the user form.

What does "ambiguous name detected~" mean?

Thank you very much for your help!

 

[Tom Ogilvy]

Sub ShowForm()
Userform1.Show
End Sub

Attach to a commandbutton

Have no idea what an indexed list it. Sounds like you are asking about
programming the functionality of your userform.


http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data



Ambiguous name means you have two routines with the same name.

 

[Guest]

Well, first you must write a macro that call show the userform ... like this:

sub ShowForm()

userform1.show

end sub

next, in Excel, create a new button on a toolbar (right-click any toolbar
and click 'Customize...' to create a new button).

Once you've put the new button on yr toolbar, right-click it, and click
'Assign Macro...' to select your new macro to run the form when it is clicked.

HTH

Philip