ppermuth
06-21-2016, 08:34 PM
Hello!
I developed a userform in a 'scrapbook' version of a primary/live workbook and it works wonderfully. A command button on one of the worksheets calls the form with the following:
Private Sub GoShopping_Click()
GrocerySelect.Show
End Sub
No error is encountered. All systems are go.
I copied the userform to the live version of the workbook (drag and drop). I also copied the command button to the same worksheet in the live version. The code is exactly the same:
Private Sub GoShopping_Click()
GrocerySelect.Show
End Sub
When I try to use the button in the live version, however, the following error gets thrown:
run time error 1004
method 'range' of object'_Worksheet' failed
and going to 'Debug' from the error window, the following line is highlighted:
GrocerySelect.Show
I can't figure out why the copied version to the live workbook doesn't work/what I need to change so that it does. I would greatly appreciate help on this!
Thank you!
I developed a userform in a 'scrapbook' version of a primary/live workbook and it works wonderfully. A command button on one of the worksheets calls the form with the following:
Private Sub GoShopping_Click()
GrocerySelect.Show
End Sub
No error is encountered. All systems are go.
I copied the userform to the live version of the workbook (drag and drop). I also copied the command button to the same worksheet in the live version. The code is exactly the same:
Private Sub GoShopping_Click()
GrocerySelect.Show
End Sub
When I try to use the button in the live version, however, the following error gets thrown:
run time error 1004
method 'range' of object'_Worksheet' failed
and going to 'Debug' from the error window, the following line is highlighted:
GrocerySelect.Show
I can't figure out why the copied version to the live workbook doesn't work/what I need to change so that it does. I would greatly appreciate help on this!
Thank you!