Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
POP UP asks values for different cells
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??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
POP UP asks values for different cells
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" wrote in message oups.com... 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??? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
POP UP asks values for different cells
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
POP UP asks values for different cells
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... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
POP UP asks values for different cells
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when I click on Help, Excel asks for CD ROM | Setting up and Configuration of Excel | |||
thanks 2 everybody here who asks questions & answers them! | Excel Programming | |||
How do I set up an argument which asks for multiple criteria | Excel Discussion (Misc queries) | |||
System asks to save when no changes made? | Excel Programming | |||
Macro that asks for password | Excel Programming |