Ray Erden
asked on
Excel 2010 Form Control Combo Box Manipulation
I am trying to achieve something which can easily be achieved with an active X combo box on Excel. I have a form control combo box, the input range is in column A. In addition to the values that the drop down box shows I also want the ability to manually put in a value that is not in the input range. I could do that using active x control combo box but need to eliminate this as some users with Mac are having problems and also ran into other issues with active x control objects on the file.
Is it possible to achieve this using form control combo box? Is there any way to manipulate this form control via VBA to do that?
Attached is my sample file illustrating what I just described above.
C--Users-rerden-Desktop-FormControl.xlsx
Is it possible to achieve this using form control combo box? Is there any way to manipulate this form control via VBA to do that?
Attached is my sample file illustrating what I just described above.
C--Users-rerden-Desktop-FormControl.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I understand that form control combo box is not supporting the functionality that I am trying to implement. Already used validation drop down box with error option box checked. Unchecked that box so no error will pop up if something else is entered other than what the list shows. Like I said I was able to achieve what I wanted to do with Active X type combo box but some of the users with Mac machines are having problems with that as Mac is not supporting this technology. In addition to that having Active X control objects on the file was causing problems after using File>Print. All the objects were being shifted on file although the printout was looking good. I eliminated this issue either via custom print macro or the complete removal of all the active x controls from the file and doing regular File>Print. Long story short I will stick to validation drop down boxes with error function disabled so user can input a value outside of the items in the list.
Thank you!
Thank you!
ASKER
Thank you Saurab and Martin.
You're welcome trusxlsol!
Thank you Saurab and Martin.You selected Saurabh's and sktneer's soultions. Is that what you meant to do?
28708602l.xlsx