Dear Sir,
I have a sheet in this sheet in column B1:B100 list of companies name .
Now my Question is :
I have prepared a combo box in userform , I want to take list in prepared combobox of sheet's column B1:B100.
IN SHORT B1:B100 LIST SHOWS IN A COMBOBOX ( REVERSE ENTRY )
is this possible ?
can u give me code in vba and also excel formula .
Last edited by sa.1985; 09-12-2012 at 06:52 AM.
From :
Sa.1985
Any idea for my above question ?
Hellow!
I can help you with that.
Since you already made a list of companys insert this forumla into your userform.
If you change the few things I have posted you should be good. Also If later you add a company to say B101 or higher to B240 The comany name will appear in the combo box.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks