Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change colour
hi all,
Is there a way in a form to make a button that on click will change the colour of text on words I select ? many thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change colour
Private Sub CommandButton1_Click()
Dim myCell As Range For Each myCell In Selection.Cells myCell.Font.ColorIndex = 50 Next myCell End Sub "millwalll" wrote in message ... hi all, Is there a way in a form to make a button that on click will change the colour of text on words I select ? many thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change colour
Hi Greg,
Thanks for that, only problem I have is when I change colour it does not show in the form the new colour. I need to be able to select code change colour of it and the change to show in the form. The user will use this to mark what serial key's have been used and whats ones have not be used. With the code you gave me works but it only makes changes to the excel page what they wont be able to see. Is there anyway to make the changes show in the form ?? Thanks again "millwalll" wrote: hi all, Is there a way in a form to make a button that on click will change the colour of text on words I select ? many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if cell colour is then change cell colour in range | Excel Programming | |||
HOW TO CHANGE ROW COLOUR | New Users to Excel | |||
change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
Code to change interior colour only if current interior colour is | Excel Programming | |||
IF... change colour | Excel Programming |