VBA form basics

[Colin Foster]

Hi,
I need to be able to create a VBA form in Excel to show the entries within
my spreadsheet. The form will be used to both add new entries and view
existing ones. Some of the data within the form is a telephone call log, so
it would be nice if these could be on seperate "pages" within the form.
Now the problem is how to get started... I would have preferred to use
Access, but I've been told that I have to use Excel. The basic spreadsheet
is already designed with some columns having data input restricted to
selected named ranges (using Data>Validation), but I would like a form to
ease use of the spreadsheet.
In addition (not asking for much beyond the moon!), is it possible to apply
an autofilter on the basic spreadsheet & the form only show the filtered
records, or is this possible within the form itself?
If this was access, I'd be resonably comfortable, but I've never set up a
UserForm in Excel, hence the request for advice.
If there are any good tutorials on the net that cover this, then please
point me in their direction. I've had a look myself, but the ones that I've
found don't seem to go into the level of detail that I think that I need
Regards
Colin Foster

 

[Guest]

Here is a very basic reference
http://msdn.microsoft.com/library/d...xlhowCreatingaCustomDialogBox1_HV05200213.asp

Here is a step-by-step that is related to what you want:
http://support.microsoft.com/default.aspx?scid=kb;en-us;213749