Use cmd button to move cursor to a cell populated with a user date

[Conner]

I have an excel spreadsheet with a date column. The dates are entered in sequence -- 1700, 1701, 1702 and so on.

I need a command button with a VBA procedure that will take the cursor to the cell of a specific date when the user enters that date in a text box.

 

[PHV]

Take a look at the VLookup WorksheetFunction

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244