I am using the following VBA code line in Excel 2003 to prompt for a symbol:

UserVal = UCase(Application.InputBox("Symbol?", , MyLastSymbol, , , , , 2))

and it works fine. The "MyLast Symbol" places a defaulted value there for me
to accept automatically or change the input.

But, I have an occasion where what I really need is to prompt for a value to
be assigned to a variable based on the next selected cell I would click on.

If I could combine this with the InputBox format, that would be great.

My thanks in advance for any suggestions.

Brad

How do you know on which cell you will click next?


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Brad" wrote:

> I am using the following VBA code line in Excel 2003 to prompt for a symbol:
>
> UserVal = UCase(Application.InputBox("Symbol?", , MyLastSymbol, , , , , 2))
>
> and it works fine. The "MyLast Symbol" places a defaulted value there for me
> to accept automatically or change the input.
>
> But, I have an occasion where what I really need is to prompt for a value to
> be assigned to a variable based on the next selected cell I would click on.
>
> If I could combine this with the InputBox format, that would be great.
>
> My thanks in advance for any suggestions.
>
> Brad
>
>
>

Brad,

Use 10 (8, for range selection, + 2, for string, (either can be used, then)
as the last parameter of your imputbox...

UserVal = UCase(Application.InputBox("Symbol? Type or select a cell", ,
MyLastSymbol, , , , , 10))

HTH,
Bernie
MS Excel MVP


"Brad" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am using the following VBA code line in Excel 2003 to prompt for a
>symbol:
>
> UserVal = UCase(Application.InputBox("Symbol?", , MyLastSymbol, , , , ,
> 2))
>
> and it works fine. The "MyLast Symbol" places a defaulted value there for
> me to accept automatically or change the input.
>
> But, I have an occasion where what I really need is to prompt for a value
> to be assigned to a variable based on the next selected cell I would click
> on.
>
> If I could combine this with the InputBox format, that would be great.
>
> My thanks in advance for any suggestions.
>
> Brad
>

Well, I don't but the cell I will be looking for will be from a column of
index values. Once the index number is assigned via this operation to a
variable, it will determine the input range for a chart.

Thanks, Brad


"Wigi" <(E-Mail Removed)> wrote in message
news:1DAD9FE6-65AC-41CA-9BA7-(E-Mail Removed)...
> How do you know on which cell you will click next?
>
>
> --
> Wigi
> http://www.wimgielis.be = Excel/VBA, soccer and music
>
>
> "Brad" wrote:
>
>> I am using the following VBA code line in Excel 2003 to prompt for a
>> symbol:
>>
>> UserVal = UCase(Application.InputBox("Symbol?", , MyLastSymbol, , , , ,
>> 2))
>>
>> and it works fine. The "MyLast Symbol" places a defaulted value there for
>> me
>> to accept automatically or change the input.
>>
>> But, I have an occasion where what I really need is to prompt for a value
>> to
>> be assigned to a variable based on the next selected cell I would click
>> on.
>>
>> If I could combine this with the InputBox format, that would be great.
>>
>> My thanks in advance for any suggestions.
>>
>> Brad
>>
>>
>>