Range Variable (From Cell Value)

[RudRud]

Hi Gurus,

If vbNo , inpboxa & b will become as a range variable, therefore when i put inpboxa.select it will be selected

However if vbYes, inpboxa cant be select. Any quick thoughts for selecting an inpboxa when vbyes? Thanks

Sub test()

answer = MsgBox("Last Range (Yes), New Range(No) ", vbYesNo)
If answer = vbYes Then
inpboxa = Range("b2").Value
inpboxb = Range("b3").Value

ElseIf answer = vbNo Then
    Set inpboxa = Application.InputBox(Prompt:="Select a range", Type:=8)
   Set inpboxb = Application.InputBox(Prompt:="Select a range", Type:=8)
   Range("b2").Value = inpboxa.Address
   Range("b3").Value = inpboxb.Address
End If

inpboxa.Select
End Sub

 

[Joe4]

I will take note for that and i'll try to be more clearer in the future. Thanks for the fast response anyway

You are welcome.

I would recommend using "Option Explicit" in all your code, which requires you to declare all variables before using them.
This will help in debugging and cut down on errors/typos.
See this article to see how to automatically turn it on for all new projects: How to use Option Explicit Statement in VBA

 

[RudRud]

You are welcome.

I would recommend using "Option Explicit" in all your code, which requires you to declare all variables before using them.
This will help in debugging and cut down on errors/typos.
See this article to see how to automatically turn it on for all new projects: How to use Option Explicit Statement in VBA

Noted, Thanks for your kind sharing. It means a lot for us to grow everyday