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.

--
Cheers,
Shane Devenshire


"Stee n" wrote:

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
see this site for starts..
http://www.contextures.com/xlUserForm01.html
http://www.contextures.com/xlUserForm02.html

regards
FSt1

"Stee n" wrote:

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

You could look at John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm

The source code is available for a small fee ($20 USA, IIRC). So you can modify
it as much as you want.

And a couple more references for userforms:

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

Stee n wrote:

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

--

Dave Peterson