View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ewing25 Ewing25 is offline
external usenet poster
 
Posts: 62
Default Input Box Trouble

I am trying to make it so that when a user inputs the amount of trips they
have taken, Excel automatically copys that amount of worksheets.

I made a Macro that copys the worksheets but im not sure how to integrate
that into an input box.

the copy sheet code:

Sheets("Individual Trip").Select
Sheets("Individual Trip").Copy After:=Sheets(3)

Thanks!