Hey

I'm quite new to this VBAing in Access and I'm having a bit of a
problem here.

I have coding which allows an input box to appear when a button is
pressed......

Dim varInput As String

varInput = InputBox("Select your cell?")


First I would like the user to click on a cell to populate the formula
bar with the text they want to search for. Then they click on the
button and the input box pops up. However I want the input box to be
populated with the text from the formula bar.

Is this at all possible?

Cheers

Dave


--
David494
------------------------------------------------------------------------
David494's Profile: http://www.excelforum.com/member.php...o&userid=24482
View this thread: http://www.excelforum.com/showthread...hreadid=391278