View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jacy Erdelt[_2_] Jacy Erdelt[_2_] is offline
external usenet poster
 
Posts: 5
Default Find a sheet within a workbook (If/Then/Else)

I have several sheets within a workbook. What I would like the program to do
is search through the sheet names and if there is a sheet name = to
txtName.Value then perform action, otherwise show a message telling the user
the input is not valid. I have already written the "then" and "else" portion
of this code, but I don't have the slightest idea how to have the program
search through the sheets to find the correct one (the "If"). Please help!