Hi all,

Thanks for any direction this request€¦

I have a workbook that has a number of macro buttons and combo boxes that
control views and €˜stuff within the worksheet.

Is there a website or any information I can get hold of that will allow me
to transfer all these buttons etc on to a user form, I would like to know how
to call up the user form and basically some more information on using them.

Thank you
Andy

See

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.

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

http://support.microsoft.com/default.aspx?kbid=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp

Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Andy the yeti" wrote in message
...
Hi all,

Thanks for any direction this request.

I have a workbook that has a number of macro buttons and combo boxes that
control views and 'stuff' within the worksheet.

Is there a website or any information I can get hold of that will allow me
to transfer all these buttons etc on to a user form, I would like to know
how
to call up the user form and basically some more information on using
them.

Thank you
Andy

Thank you

"Bob Phillips" wrote:

See

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.

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

http://support.microsoft.com/default.aspx?kbid=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp

Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Andy the yeti" wrote in message
...
Hi all,

Thanks for any direction this request.

I have a workbook that has a number of macro buttons and combo boxes that
control views and 'stuff' within the worksheet.

Is there a website or any information I can get hold of that will allow me
to transfer all these buttons etc on to a user form, I would like to know
how
to call up the user form and basically some more information on using
them.

Thank you
Andy