View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Paxson Gary Paxson is offline
external usenet poster
 
Posts: 3
Default Using VB to change sheet name to match cell contents

Is there an easy way using VB to change the currently
active sheet's name to a cell value?

Scenario:
---------
I have a time reporting sheet which uses an employee
name validation pulldown to select and show work time
statistics for any of my staff.

I'd like to create a complimentary VB function which
changes the sheet's name to match that of the currently
selected employee, preferably via a changed cell action,
but I'd settle for creating a button control to accomplish
the sheet name change.

Any suggestions or code examples would be appreciated

Thx - GP