Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Kuhaylah Malik   on Nov 12 In MS Office Category.

  
Question Answered By: Saila Iqbal   on Nov 12

First two obvious errors are:

dim myshape is shape
should be
dim myshape as shape

Object names cannot have spaces in them so

"Drop Down 9"

should be (probably) "DropDown9"

If any line is red in the VBA editor it has an error and needs to be
corrected.

Then click debug/compile in the VBA editor menu and it will tell you other
errors. When these are corrected and it compiles correctly you try running
it. There may be runtime errors.

Share: 

 

This Question has 12 more answer(s). View Complete Question Thread

 


Tagged: