On 28 feb, 12:24, "Bob Phillips" wrote:
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" wrote in message

ups.com...


ok thanks

i've done that and it works just fine

thankx for your help
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- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -