Usoki
09-27-2008, 09:14 PM
:omg2: I cannot, for the life of me, figure out the proper commands. I've looked all over the help manuals, but I can't seem to get the right keywords to search for what I want the userform to do.
I have a series of textboxes in the userform, enabled set to false so that they cannot be written in, that I would like to display values from the spreadsheet the userform appears from. That is, I would like the value from a cell to appear inside of the textbox when I open the userform. If the value of the cell E5 is "4", then I'd like the matching textbox to have the value "4" inside of it when the userform is shown, and that value cannot be editted from the userform. The only way to change it would be to close the form, change the value in E5, and restart the userform.
But no combination of value, text, and range commands are working for me. What am I doing wrong?
I have a series of textboxes in the userform, enabled set to false so that they cannot be written in, that I would like to display values from the spreadsheet the userform appears from. That is, I would like the value from a cell to appear inside of the textbox when I open the userform. If the value of the cell E5 is "4", then I'd like the matching textbox to have the value "4" inside of it when the userform is shown, and that value cannot be editted from the userform. The only way to change it would be to close the form, change the value in E5, and restart the userform.
But no combination of value, text, and range commands are working for me. What am I doing wrong?