Need a macro

[JasonLevan]

Column A Column B Column C

248.............. test.................4
2410............ test2................10

I need a macro that I can imput a number from column A into that will return then Info in column B in that message box and the info into column C, but give me the option of overriding the number in column C to a new number, then contining on to the next number i imput, I realize that this is more a job for access but done have access. Any thoughts

 

[smiler44]

I think you are going to need somthing like a textbox and a command button to do what you want as the data you want to search for varies. If you dont want the command button and test box on your Excel spread sheet then you can create a custom tool bar. This will allow you to have the text box pop up for you to enter the data to search for. If you have excel 2007 you will be limited on the icons you can use on the toolbar, if you have Excel 2003 then you have more choice and can create your own.
If you need code as well, repost
smiler44

 

[smiler44]

just found this code on this forum from a question and reply from another thread, beats a text box and command button. its not all the code you require but its a good start. i've remmed a line as you wont want it

Sub DeleteRow1()
Dim i As Integer
i = InputBox("Please enter a number")
Range("A2").Select
Do Until ActiveCell.Value = i
ActiveCell.Offset(1, 0).Select
Loop
'ActiveCell.EntireRow.Delete
End Sub

 

[SpentGeezer]

Use this demo to get some ideas: