How do I fill up a table from an imput panel?

L

Lii

The idea is to fill up a long table without going to the cell
themselves, but rather by specifying the value and the cell itd g
into.
PLzHel
 
C

crispbd

Open the VB Editor (Alt + F11), next to the project explorer right
click,
Insert-> Module


Double Click the Module, add the following procedure:


Sub AssignValueToCell()

TargetCell = InputBox("Enter Target Cell")
NewValue = InputBox("Enter Value For Cell " & TargetCell)
Range(TargetCell).Value = NewValue

End Sub

Close the VB Editor, then go to
Tools->Macros-> AssignValueToCell
 
D

Dave Peterson

Since you're using a nice table, you may want to try Data|Form.

And if that's too restrictive, John Walkenbach has an enhanced form that's even
nicer:

http://j-walk.com/ss/dataform/index.htm

The code is available if you want to see the secrets (and modify it for your
use!).
 
L

Lii

Thanx a lot to all of you for your help!

CRISPBD, I found your reply particularly usefull, but could you pleas
help me introduce a little variation to the code you proposed?

Instead of assigning the target Cell in the format Letter, Numbe
(example: A1), Id like to introduce it in the format X-Parameter
Y-Parameter of my table (example: Month, Day of the Month). This i
because the user wont know the cell he has to introduce the value to
but rather which day hes got to introduce the value to.

Is this possible?
Hope i made myself clear. Thanx a lot for your help
 
Top