View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sue Sue is offline
external usenet poster
 
Posts: 285
Default Find Number On Active Sheet

Hi All

I have a TextBox on a Userform TB1 I want to enter a number in the text box
click a CommandButton Com1 and find a number listed in column F - starting
from Row3 and ending in Row94 using the active sheet in the workbook. The
numbers are set to Text because I use a lot of leading zero's (any way of
getting rid of that annoying green tag on each cell) Is it possible to have a
macro that will do this and if so can you please guide me in the right
direction.
--
Many Thanks

Sue