View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] koperstexdq_dont_use@gmail.com is offline
external usenet poster
 
Posts: 28
Default Input box, find number and go to cell

Hi
Can someone help with a macro doing the following?

1. Open an Inputbox (User then writes a number with four digits)
2. Search for the number in column A (from start to end. The number will
will be present only once)
3. Go to the cell with the found number
4. If the number is not found a message box should pop up telling this.

Thank you
Kaj Pedersen