• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

dinner planner error message

DAGUET

Member
dear VBA experts.

i have built a dinner planner userform .
i was convinced that everything was right, until I got the error .

i really cant see where this issue can come from
any help to fix it most welcome!!
 

Attachments

  • Trial.xlsm
    24.9 KB · Views: 6
You are midding

'Empty CityListBox
CityBoxList.Clear

DataCheckBox1.Value = False
DataCheckBox2.Value = False
DataCheckBox3.Value = False

etc

Add Me keyword before the coltrol, so that the intellisense will show you available control names.

e.g
Me.DateCheckBox1
 
Back
Top