Userform combo box triggering macros

Giganews Newsgroups
Subject: Userform combo box triggering macros
Posted by:  michaelberrier (michaelberri…@gmail.com)
Date: 9 Jun 2006

I'm using a UserForm with a Combo Box that displays the numbers 1-10 as
choices.  I need a different macro to fire based on whatever number is
selected.  I've tried many of the solutions offered by previous posts,
but I can't make it work.  i.e.: Should the user select "1", then the
macro "makeman1" will execute and so forth through "10".

Thanks in advance.  Please be specific in any reply about how the
syntax should be.

Replies