input box

[still learning]

Hi
What am I doing wrong????
this works

Sub box()
Name = InputBox("name", 3)
Range("A1").Value = name
End Sub

and this doesn't

Sub box1()
Name = InputBox("Start", 3)
Range("A1").Value = Start
End Sub

mike

 

[Michael M]

You are trying to use Start as a variable for name, when "Start" is simply the title of the InputBox

Sub box1()
Name = InputBox("Start", 3)
Range("A1").Value = [color=red]Start[/color] 'change to Name variable
End Sub

 

[still learning]

Duh...I couldn't see the forest because of all the trees

Thank you

I'll post this question under a different tittle if needed:

is there a way to make this work?

Application.Goto Reference:=  >>>>what IS in A1<<<<

The user will put a cell number (example--F480) in the input box
then I want the cursor to go to that cell
then I have a macro to continue


mike

 

[Michael M]

Like this ??

Sub box1()
n = InputBox("Start", 4)
Range(n).Select
End Sub

 

[still learning]

Hi Michael M

Yep, that's what I need.

A minor point....I had to change the sub name because every time I clicked on it, the cursor would go to cell>>>BOX1.

Thank you for the help

mike

 

[Michael M]

Yeah, try to avoid using any Sub names or Variable names that VBA might confuse as Native commands..

 

[still learning]

I remembered that after the cursor kept going to BOX1

Is it possible to have the input box have a default of B so when the user enters the cell number he/she doesn't have to put in the letter. It will always be in B row


mike

sorry about adding questions but i'm only thinking of them as i write the code


mike

 

[Michael M]

Just input number only

Sub location()
n = InputBox("Start", 3)
Range("B" & n).Select
End Sub

 

[still learning]

Thank you Michael

works perfectly.

I added an error line to exit the macro

That will be enough tonight. Its 9:30 here..PM

I'll probably have more questions when I add the other macros to it.

Thanks again and Merry Christmas


mike



"If that offends, think of it as a generic term for this time of year"

 

[Michael M]

Cheers mate, have a good one...