Question
Hi Daryl
Sub Test()
Cells.Find(What:=InputBox("Now what"), _
LookIn:=xlFormulas, _
LookAt:=xlWhole).Activate
End Sub
HTH. Best wishes Harald
"Daryl Timm" skrev i melding
ink.net...
How would I go about writing VBA code that will ask for the user to input
number that the macro will then search for?
I will be using this macro to look for promotion numbers that change
quarterly and I would like to be able to have a message box pop up asking
for the promo number. After I enter the promo number, the macro would
search for the number I entered.
Thank You.
Daryl Timm
|