User Forms - Tips needed to get started

  • Thread starter Thread starter Stee n
  • Start date Start date
S

Stee n

Hi All

I would appriciate some help to where I can get some information on how to
make a user form for my excel sheet.

Basic is that I would like the following informationh shown in a user form
like when using DATA->FORM, but with another desigen of the user form. I
would for instance like I text field with a scroll bar, Posiblity to select
from a List, lock some fields for editing, Limit values on others, put in
date values using a calendar (I have the calender already :-))

Is there a site where I can find this kind of information or can anyone help
with some guidens to the above.

The problem is that my excel sheet has a lot of columns and when using the
projector it's kind of irritation to scroll forth and back all the time for
each task set for example different status values. I would be nice two have
display/edit this in a well organised user form instead.

Any advice will be much appriciated

/Steen
 
Hi Steen,

I personally don't think much of Data, Form amongh other things you can't
customize them.

You will need to explore User Forms in VBA.

John Walkenbach book Excel 2007 (or the 2003 version) Power Programming with
VBA has a number of chapters on this topic and should give you a great start.
 
Back
Top