Userform textbox wordwrap/dare format rowsource

[mahmed1]

Hi all


i have a problem on a few things


1) I have a text box where a value is populated automatically based on the colour selected. How do I have this textbox so that there is no cursor there and I can't select it and it's for read only?


2) I populate a cbo box with months from a sheet but the data show as numerical value and not dare format
ie cbodata.rowsource = "sheet1!h2:h20"


3) I have a text box to input notes rectangles shape
when input text, the text goes forever
how can I word wrap it so that when it goes to end of the size of textbox, it moves to next line
the word wrap is on so not sure why this ain't working

4) i also have 2 userforms. If i press add colour then this 2nd userform pops up with a colour picker. Once i select the colour, i change a lablel background in my userform1 and then i close this 2nd userform.
Now what i want to do is also have this userform2 (colour picker) pop up when i double click a cell and then once selected, change the cell called from/active cell colour to the colour picked. So this one will not refer to userform1.

so what i need is to have an if statement and see who called this userform 2
was it from a button on userform 1 or a cell on spreadsheet
if userform 1 then change label on userform1 colour to what i selected
or
if called by cell double click then change the active cell colour to what i selected

please help me

 

[mahmed1]

Hi

is there a workaround or tip/technique i can use to get around this.

i dont know what technique but something like have a dummy cell update or send keys or something?

 

[Andrew Poulsom]

If there was I would have told you. You could calculate the workbook in the procedure(s) that change the colour.