User Prompt VBA

Feb 21st, 2002, 10:06 AM

Hey, I Was wondering how it would be possible to prompt the user throgh adding a number in each cell they have to, so basically a message box appears, asking for the data. a bit like a swithcboard on access, something which guides the user trhough the cells they have to put information into, so they dont have to work out which one to select. i have invistigated input function, but the value entered into a box doesn't actually enter into the spreadhseet? could someone explain to me how to do this? hope i made it clear!!

Feb 21st, 2002, 11:17 AM

Please help!!!

RWinfield · Feb 21st, 2002, 11:24 AM

One way to do it would be to select the cells you want the user to be able to input to and change the property on them to unlocked. Then use data validation to create a drop down list for each of those cells with the possible inputs. Then protect the worksheet and the user should be able to tab only to the unlocked cells, select an item from the drop down list in that cell, then tab to the next cell.

Hope this heads you in the right direction,

Rick

Feb 22nd, 2002, 05:07 AM

Hi. I think you're looking for something like this:

Worksheets("Assumptions").Range("B7").Value = InputBox("How many bananas?, "[TITLE OF SCREEN]", "[DEFAULT VALUE")

This gives you a dialogue box, prompting for a number of bananas. Enter any number, which then is "entered" into cell B7 on the Worksheet titled "Assumptions".

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 10:06 AM	#1
Guest Posts: n/a	Hey, I Was wondering how it would be possible to prompt the user throgh adding a number in each cell they have to, so basically a message box appears, asking for the data. a bit like a swithcboard on access, something which guides the user trhough the cells they have to put information into, so they dont have to work out which one to select. i have invistigated input function, but the value entered into a box doesn't actually enter into the spreadhseet? could someone explain to me how to do this? hope i made it clear!!

Feb 21st, 2002, 11:24 AM	#3
RWinfield New Member Join Date: Feb 2002 Location: Washington State Posts: 33	One way to do it would be to select the cells you want the user to be able to input to and change the property on them to unlocked. Then use data validation to create a drop down list for each of those cells with the possible inputs. Then protect the worksheet and the user should be able to tab only to the unlocked cells, select an item from the drop down list in that cell, then tab to the next cell. Hope this heads you in the right direction, Rick

Feb 22nd, 2002, 05:07 AM	#4
Guest Posts: n/a	Hi. I think you're looking for something like this: Worksheets("Assumptions").Range("B7").Value = InputBox("How many bananas?, "[TITLE OF SCREEN]", "[DEFAULT VALUE") This gives you a dialogue box, prompting for a number of bananas. Enter any number, which then is "entered" into cell B7 on the Worksheet titled "Assumptions".