locks3
asked on
Excel Userform to write back to spreadsheet in a different font or colour
Hi,
I have a spreadsheet where a User keeps track of numbered Jobs.
The current Userform can be updated with more information as Jobs progress.
Is there any way to write back the data in a different font or colour ?
We want to use "strikeout" font on cancelled Jobs (rather than have a new field in the spreadsheet).
I will put a "cancelled Job" button on the Userform for this purpose (with all the appropriate controls).
Example of current code to write back data is:
r = worksheetfunction.match(Va l(JobBox), Ws.columns(1), 0)
currentrow = r
Me.firstnamebox = ws.cells(r, "b")
Me.lastnamebox = ws.cells(r, "c")
Me.Phonebox = ws.cells(r, "d")
Me.AgeBox = ws.cells(r, "e")
....etc,etc
cheers (P.S. Have not done this forum stuff for a zillion years so a bit out of date )
I have a spreadsheet where a User keeps track of numbered Jobs.
The current Userform can be updated with more information as Jobs progress.
Is there any way to write back the data in a different font or colour ?
We want to use "strikeout" font on cancelled Jobs (rather than have a new field in the spreadsheet).
I will put a "cancelled Job" button on the Userform for this purpose (with all the appropriate controls).
Example of current code to write back data is:
r = worksheetfunction.match(Va
currentrow = r
Me.firstnamebox = ws.cells(r, "b")
Me.lastnamebox = ws.cells(r, "c")
Me.Phonebox = ws.cells(r, "d")
Me.AgeBox = ws.cells(r, "e")
....etc,etc
cheers (P.S. Have not done this forum stuff for a zillion years so a bit out of date )
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you have problems then attach the workbook then I can check it for you
Just to add, you do not need to use each line, just the ones that you need, e.g. Strikethrough = True
ASKER
Worked perfectly exactly as needed. Many thanks
Pleased to help
ASKER
Roy, just tweaked it a bit with an Interior "color"(yuk -americano) of yellow so now really stands out !
Thanks for a "sensible" answer. (malc in OZ)
Thanks for a "sensible" answer. (malc in OZ)
Glad you sorted this one. You need to close the question by allocating the points
ASKER