See workbook attachment:
Combobox.xlsm
I like ActiveX combobox, because I can make the font size bigger, and many other things. BUT I have no clue how to get it all setup. Keep in mind I'm a laymen for programming. I did, however, setup a workbook with the combobox and a worksheet where all the data goes! (see attachment)
RANGE:
I need the Range to be a list of names : Sheets("Accounts").Range("F6:F11")
CELL LINK:
I need to Cell Link to be :
- EITHER: Sheets("Accounts").Range("G2") (in number format like it is with regular comboboxes)
- OR: Sheets("Accounts").Range("F2") (in name format, whatever name is selected)
Please help!
Bookmarks