Results 1 to 8 of 8

ActiveX ComboBox selection writes multiple cells

Threaded View

darmstrong ActiveX ComboBox selection... 05-11-2007, 11:05 PM
Leith Ross Hello David, The best... 05-12-2007, 02:17 AM
darmstrong Wow, thanks for the prompt... 05-12-2007, 04:13 AM
Leith Ross Hello David, I made the... 05-12-2007, 02:29 PM
darmstrong Leith, That's pretty much... 05-13-2007, 10:00 AM
Leith Ross Hello David, I have added... 05-14-2007, 01:45 AM
darmstrong Names function 05-18-2007, 05:45 AM
darmstrong Leith, Well, I finally did... 05-30-2007, 10:31 PM
  1. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello David,

    I have added the functions you wanted to the attached workbook. The row is determined by the cell the ComboBox occupies, so you don't need to pass any variables. Just be careful of future placements. You will have to enter a single line of code for each ComboBox's Click() event. You will see the code on Sheet1. Everything else is automated.

    Sincerely,
    Leith Ross
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1