View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
gocush[_29_] gocush[_29_] is offline
external usenet poster
 
Posts: 252
Default Referencing cells with input boxes.

George,
There are numerous ways to get input from a user: one of the simpler ways in
to use a cell with validation:
Say you want the user to enter a number in Cell A1. You click on A1 then on
the menu item at the top: DataValidation Then select say Whole numbers and
you fill in the min and max. Or if you want to limit the input to a specific
list of numbers, click on List, then in the RefersTo box at the bottom enter
some numbers separated by commas: 6,12,10,4,25
I like to use this List with the name of a range in the RefersTo box:
=MyList.
then on one of the worksheets I have a list of numbers or text. I select
this list and give it a name in the Name Box (to the left of the formula bar).

Once the user provides the input, you can have links to the input cell. Say
you want to use the user's input in cell F25. Then in F25 you enter: =A1,
or =A1+C25, or whatever.

"George Sherman" wrote:

Please help this newbie. I want to get a number from a user and transfer that
number to a cell in my worksheet so I can use that number in other formulas.
Any good suggestions or good reference material I might access would be
greatfully and humbly appreciated.

George