Manipulating InputBox variable

**elprup** · 10-20-2009, 10:59 AM

I have two inputboxes. I want to set the default value of the second inputbox as (effectively) one cell down from the first inputbox entry. In other words, if I type G17 into the first inputbox, I want the second inputbox to then have a default value of G18.

Please and thank you.

**royUK** · 10-20-2009, 11:03 AM

Not sure what you are doing, but you can use an inputbox to select a range

**DonkeyOte** · 10-20-2009, 11:04 AM

for more info. on Roy's point see: http://msdn.microsoft.com/en-us/libr...ffice.11).aspx (specifically type 8)

**elprup** · 10-20-2009, 11:35 AM

I don't want the inputbox to reference a range object. I don't know...let me reword:

I think what I'm asking is how to manipulate a text result as though it were a (pretend) range? When I type "G17" into the first inputbox, I want "G18" to be the default text that shows up in the second inputbox. I can't figure out how to take the text "G17" and turn it into "G18."

**DonkeyOte** · 10-20-2009, 11:46 AM

Not sure I follow why you would want this but...

Please Login or Register  to view this content.

**elprup** · 10-20-2009, 02:54 PM

Beautiful! That's what I was after; thank you.

As far as why, I just thought it'd be a nice touch to have the default value of the second input box dynamically change based on the user input of the first input box...and I was right, it is a nice touch!

Thanks again.