excel - Run-time Error 424 Object Required UserForm doesnt exist -


i'm attempting things written on site www.excel-easy.com when click commandbutton (from activex controls) in worksheet website instructed, nothing happens. tried use button form controls, says error in ---> dinnerplanneruserform.show

my code:

sub button2_click()     dinnerplanneruserform.show end sub 

when used f8, said error here --> private sub userform_initialize()

private sub userform_initialize()      'empty nametextbox     nametextbox.value = ""      'empty phonetextbox     phonetextbox.value = ""      'empty citylistbox     citylistbox.clear      'fill citylistbox     citylistbox         .additem "san francisco"         .additem "oakland"         .additem "richmond"     end      'empty dinnercombobox     dinnercombobox.clear      'fill dinnercombobox     dinnercombobox         .additem "italian"         .additem "chinese"         .additem "frites , meat"     end      'uncheck datacheckboxes     datecheckbox1.value = false     datecheckbox2.value = false     datecheckbox3.value = false      'set no car default     caroptionbutton2.value = true      'empty moneytextbox     moneytextbox.value = ""      'set focus on nametextbox     nametextbox.setfocus  end sub 

this error can occur when remove or delete textbox form, forget remove line in initialization eg:

private sub userform_initialize()     commandbutton2.enabled = false     textbox4.enabled = false    'textbox deleted form end sub 

Comments

Popular posts from this blog

android - Gradle sync Error:Configuration with name 'default' not found -

java - Andrioid studio start fail: Fatal error initializing 'null' -

html - jQuery UI Sortable - Remove placeholder after item is dropped -