LinkBack URL
About LinkBacks
Hello,
I was advised that the cells in a sheet cannot be the same as a Textbox in a Userform - However can the formatting be passed to a cell from the textbox in a Userform?
JOhn
Hello,
I was advised that the cells in a sheet cannot be the same as a Textbox in a Userform - However can the formatting be passed to a cell from the textbox in a Userform?
JOhn
What do you mean by formatting? Are you trying to choose the font or fill color...?
Ben Van Johnson
Cell Field color
Example of code in textbox in Userform
Please Login or Register to view this content.
Passing it back to my sheet:
Any Thoughts?Please Login or Register to view this content.
Use something like this:
Please Login or Register to view this content.
ProtonLeah,
Is this placed in a current code I have above or is this an addition to the code?
I'm still guessing, but try:
Please Login or Register to view this content.
ProtonLeah,
This diod not effect the color of the Quality Cell in the EmployeeData Sheet
John
Maybe a sample workbook with sensitive info deleted. This is what I think you are asking for: The form has tow textboxes and the button fills the active cell and the below right with the textbox backcolors.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks