POP UP asks values for different cells

[matthias]

Hi guys,

i've programmed a macro so that a pop up asks for the values that have
to be put into a cell

this already works : sheets1.cells(1,1) = inputbox("Give value for
cell", cells(1,1))

Now i want to use this to ask for different values, so more than one
cell : for instance the cells (1,1),(2,1),(3,1)

is this possible with one pop up screen???

 

[Bob Phillips]

How about

For i = 1 To 3
sheets1.cells(i,1) = inputbox("Give value for cell", cells(i,1))
Next i


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[matthias]

Hi,

yeah but i was wondering if it possible so that the box says something
else for each cell such as

for cell 1,1 : give value for tax rate
for cell 2,1 : give value for stock price

instead of saying each time : give value for cell

 

[Bob Phillips]

It's easier to just roll them then

sheets1.cells(1,1) = inputbox("Give value for tax rate")
sheets1.cells(2,1) = inputbox("Give value for stock price")
etc.

or even just buidl a simple little userform.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[matthias]

It's easier to just roll them then

sheets1.cells(1,1) = inputbox("Give value for tax rate")
sheets1.cells(2,1) = inputbox("Give value for stock price")
etc.

or even just buidl a simple little userform.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)




ok thanks

i've done that and it works just fine

thankx for your help