Front end boxes to input data

[shaikhiy]

Hi Guys,

I need some help from you again. I am trying to devise an automtic expense claim form. I have done all the back end stuff for it, but cos we have lots of people who find it hard to use excel, I need some way of creationg pop up boxes with instructions so that they can fill in the information , and then this infomration can feed into the back sheets already produced. Questions and Instructions like "Please type your name" and "IS your car petrol??",etc.

Any sugestions???

 

[royUK]

Can you use comments to do this? If you use the >Insert Menu- Comments> you can put your instruction in the Comment box and use Validation to limit the type of answer accepted. You can also look at Drop Down boxes to slect things like Type of Car (Petrol/Diesel.etc)

 

[shaikhiy]

No, unfortunately I need soemthing more obvious. I have devised a sheet with all that on already, but my manager wants me to have something that a person (not excel minded) can simply input inofrmation with pop up boxes ( do they use VB for this??)

 

[Jim North]

Hi,

You would need to use VBA for this (using USERFORMs for the input screens. Based on the number of columns you have and the extent of editing you want done, it could be a sizable task.

 

[dmckinney]

You probably want to use userforms, which are msforms, which can then fill up your spreadsheet. (Not trivial if you've no vb experience.)

If you have vb experience, you may want to design a wizard which takes the user through the input process with forward and back buttons, and then finally fills in all the relevant data in the spreadsheet.

If you go for this approach, you may want to 'draw inspiration' from the wizards which usually are installed with Word (for new fax document etc.) The forms and vba for these wizards are visible, and if you know what you're doing you can modify them to your requirements.

So it all depends on your level of expertise. If you don't know VB then I don't think designing a wizard is the project to start learning it with.

Hope this helps,

Dave.

 

[shaikhiy]

Roy/Jim,

Can you give me an example of using USERFORM in VB. I am practically totally new in using VB, and would not know how to start using the function. If I see an example, i can start looking to amend it to use it for what i want??

Thanx for the help

Imran

 

[Jim North]

Imran,

This link has several examples of userforms that you can download and look at:

http://www.erlandsendata.no/english/downloads/userforms.htm

 

[shaikhiy]

Sorry for sounding so stupid. I think I know now what you meant by using user forms (after I wnet into VB)

thankx for your help, will try and play around with it.

^_^