Combo box macro

[Quamdar]

i am trying to use a combo box to change the properties of a text box. i think i can do this by having it look at the cell link that i sent and then changing the text box appropriately with something like this:

Please Login or Register  to view this content.

...and so on for each possible color

First of all i was wondering what the code was that i would put into the part where i typed "linked cell" to check the value of a cell (i know, i'm a newb lol).

Or if there was possibly an easier way to have a combo box change the color of a text box because I think with the way I have you would need to assign the macro to a button and then when they have selected the color they want they would have to hit the button to make it actually change colors. Not that that is too big of a deal but if there is something easier that would be a lot better.

[Quamdar]

It looks like from searching that there is a way to reference a combo box instead of the linked cell but I am not sure what it is.

[Leith Ross]

Hello Quamdar,

The lack of information in your post makes it almost impossible to know what is really happening with your code. You should post your workbook for review. It will then be a faster and simpler task to correct the problem.

[Quamdar]

i ended up figuring it out:

Please Login or Register  to view this content.

pretty much what i did was have 4 combo buttons, each one linked to a different cell. then when i pressed a button on the sheet it would check the values of those cells and depending on the value of each cell it would turn a corresponding textbox a certain color.

the only problem i was having is figuring out the "If Range("B21").Value = 1" part that would check the cells to see what their value was.

marked as solved, thanks.