Greetings all VBA Gurus,
My UserForm has a ComboBox that allows users to select the number of forms they would like to add to the current work sheet. Once the numbers of forms are selected, through the ComboBox, I'd like the exact number listed in the ComboBox to be inserted after the third sheet in the workbook. However this code isn’t working and continues to give off errors. Can someone help be debug this problem? Where am I going wrong with this code? Is it possible to insert multiple sheets at a time? Microsoft certainly thinks so however the code continues to elude me.
Your advice and opinions are greatly needed. Thanks in advance guys.
So far this is what I have:
Private Sub CommandButton1_Click() Dim x As Integer x = ComboBox.Value For numtimes = 1 To x ActiveWorkbook.Sheets("CC Request Form").Copy _ After:=ActiveWorkbook.Sheets("Sheet7") Next End Sub