Open Form Button (2003)

Topic

New Reply

Is there an easy way to open a custom form from a taskbar button? I can’t seem to code for it in VBA. I want a dropdown button with a list of various email forms I have designed to open. Can’t find any help anywhere!

Reply | Quote

Replies

Sorry if everyone knows this and I am just answering my own questions, but found this code here which is exactly what I needed.

To open ANY custom published form, put this code in the the VB Editor and add a button assigned to that macro. (you just need to know your form’s name)

Sub openForm()
Set objfolder = Application.ActiveExplorer.CurrentFolder
Debug.Print objfolder.Name
Set objItem = objfolder.Items.Add(“IPM.Note.Temp”) ‘here is where you put the form’s name
objItem.Display
Set objItem = Nothing
End Sub

NIghtNight

Reply | Quote