One for the Excel gurus!

[CodeMaster]

OK, hopefully someone can help me with this one, as either I have no Google skills, or it isn't possible.

I have a spreadsheet that is used for costing purposes. I would like to make it as idiot-proof as possible. The document currently works fine, with values pulled from lists which are pulled from vlookup and hlookup lists, but I would like to make it easier.

Is it possible for Excel to open, and then the user be presented with pop-up dialogue boxes, where you can select data from drop-downs and radio buttons, and then the selection value is entered into the appropriate cell, then the next one pops up?

For example:

EXCEL OPENS...

POPUP-1
What is the quantity?
<BOX> (Quantity typed in)

POPUP-2
What material to use?
<LIST1> 304
<LIST2> 316
<LIST3> 3CR12
<LIST4> M/S

POPUP-3
Is assembly required?
<RADIO1> Yes
<RADIO2> No

 

[dD3]

i'm sure you can do this..

try googling on how to use: Excel Macro
there should be a way to create these pop up fields in there..

good luck

 

[Budza]

Cell restrictions?

 

[ChilliGirl]

Cell restrictions?

Yes you can lock the workbook & only leave certain unlocked cells where data can be entered into ,would be the easiest way. Other way is possible but very complicated & remember that if you make changes you would have to edit these boxes as awell. So locking is better & less complicated.

 

[ChilliGirl]

Cell restrictions?

silly double post............

 

[CodeMaster]

Locking cells would work, but there are many cells spread all over that need input.
Having pop-up selections would simplify it a great deal.

I figured it would have to be done via VB and macros, was hoping someone here has done something similar before, or knows how to do it.

 

[Vegeta]

Sure easy as pie. Record a macro that puts the cursor in a field(the one the user needs to populate) and use:
MsgBox "What is the quantity?"
In the code to display a message box

Get creative with it...

 

[Dan C]

Locking cells would work, but there are many cells spread all over that need input.
Having pop-up selections would simplify it a great deal.

I figured it would have to be done via VB and macros, was hoping someone here has done something similar before, or knows how to do it.

Yes it can be done easily with VB and macros. If you want I can create you a sample sheet... just PM.