Userforms

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" <Andytheyeti@discussions.microsoft.com> wrote in message
news:61ADDB45-5DF7-4EFF-94F0-92ACF70CFBA8@microsoft.com...
> 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" <Andytheyeti@discussions.microsoft.com> wrote in message
> news:61ADDB45-5DF7-4EFF-94F0-92ACF70CFBA8@microsoft.com...
> > 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
> >
>
>
>