I am trying to set the LinkedCell property of a combo box using visual basic. I cannot find the syntax for this procedure. What I am trying to do is to copy a block of user input cells from a sheet on a button click that brings in a new combo box, with a new LinkedCell and ListFillRange. This will present the user with a new form to fill in. This can be repeated between 2 and 100 times, depending on the scenario, and is not predictable. Any help with the syntax of this would be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Setting Combo Box Properties in Excel
- Thread starter Goska
- Start date
Similar threads
- Locked
- Solved
- Locked
- Question
