Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pause
hi,
i have some code.. but i want the user to be able to enter a number in a spreadsheet that will be used in a later part of the code. the number cannot be entered before the code. it has to be entered in the middle after a certain part of the code executes. is there any way to do a pause to allow the use to enter a number/interact with the spreadsheet and then have the code resume? thanks in advance, geebee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pause
Hi geebee-
The most simplistic way is to use an inputbox asking the user to enter data in it then have the macro write the data to the cell you need it in. David "geebee" wrote: hi, i have some code.. but i want the user to be able to enter a number in a spreadsheet that will be used in a later part of the code. the number cannot be entered before the code. it has to be entered in the middle after a certain part of the code executes. is there any way to do a pause to allow the use to enter a number/interact with the spreadsheet and then have the code resume? thanks in advance, geebee |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pause
hi...
but the input/interaction is with radio buttons... is there a good approach to handlong these? thanks in advance, geebee "DStrong" wrote: Hi geebee- The most simplistic way is to use an inputbox asking the user to enter data in it then have the macro write the data to the cell you need it in. David "geebee" wrote: hi, i have some code.. but i want the user to be able to enter a number in a spreadsheet that will be used in a later part of the code. the number cannot be entered before the code. it has to be entered in the middle after a certain part of the code executes. is there any way to do a pause to allow the use to enter a number/interact with the spreadsheet and then have the code resume? thanks in advance, geebee |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
pause
Like the other guy said, but here is an example:
Sub testit() Dim X As Variant 'do your first stuff here.... 'now have the code get their input: Let X = InputBox(prompt:="Please enter the number now") 'now record that value in your cell , example here is D5. cells(5,4).value=val(X) 'now continue on... End Sub |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
pause
The radio box is on the sheets as a Form item or Control Item. If it is a
Form Item, then the radio button can be linked to a cell and the inputbox data can change the linked cell to what the user chooses. David "geebee" wrote: hi... but the input/interaction is with radio buttons... is there a good approach to handlong these? thanks in advance, geebee "DStrong" wrote: Hi geebee- The most simplistic way is to use an inputbox asking the user to enter data in it then have the macro write the data to the cell you need it in. David "geebee" wrote: hi, i have some code.. but i want the user to be able to enter a number in a spreadsheet that will be used in a later part of the code. the number cannot be entered before the code. it has to be entered in the middle after a certain part of the code executes. is there any way to do a pause to allow the use to enter a number/interact with the spreadsheet and then have the code resume? thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop / Pause a Macro using Pause button | Excel Programming | |||
pause | Excel Programming | |||
Best way to pause? | Excel Programming | |||
Pause | Excel Programming | |||
Pause? | Excel Programming |