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