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
Post a Comment