I am trying to get the title block that I have made on sheet one to show up on all the created sheets that will be in the future based on a job # inputted into the userform. I tried putting the title block on the "main" sheet and having it follow through when a job is created but the spacing gets messed up when I type in the rest of the information.
Example (2).xlsm
Your form code doesnt have any code line which adds a sheet. At which point in the code are you inserting the sheet? At that point, you can put the code
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
A new sheet is created using the form that I created. It sends the information to a new sheet based on the job #. It was working fine until I tried to add a picture and reformatted the form a bit. I don't see why that would change anything critical though. I am now getting a "Run-Time error '438': Object doesn't support this property or method". I am not sure what that means but when I hit the debug button it shows ctrl.Value = "" highlighted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks