What is the maximum value that color can take? I wrote the code below. Can I say the
min value is 0 which is the value of rgb(0,0,0)
max value is 16777215 which is the value of rgb(255,255,255)
Can I say that? Thank you very much.
MsgBox RGB(0, 0, 0)
Hi guys, i would like to combine the codes below so that you can only double click when you are logged in;
Private Sub cmdLogin_Click()
If txtPassword.Value = "1" And txtUsername.Text = "ROH1" Then
.lblInformation.Visible = False
.cmdLogin.Enabled = False...
I have created a script that pastes charts to an existing Powerpoint, however I want the Powerpoint to Save As so I have a new copy. I don't know where to start with this... I have copied my code below. Hopefully this makes sense
Thanks for the help
Hi People of the Internet,
I am struggling to find the correct line of code to change my x axis titles. I can change the color of the values but I can't find the code to change the color
Any help is appreciated
For Each excelChart In ActiveSheet.ChartObjects...
Below code fill liner I need to fill Radial Color Gradient
Public Sub RadialColorGradient()
Dim Shp As Shape
For Each Shp In .Shapes
If Shp.Name = "MyShape" Then Shp.Delete
I need outside border of table white and alternate rows having interior color RGB (211,217,,222)
Please help with the following vba code.
Dim T As ListObject
Dim c As Long
Dim i As Long
For i = 1 To Sheets.Count
For Each T In...
I was successfull in italicizing text in my textbox, but I am struggling with turning the italic format off to return the text to normal.
.pin.Enabled = True
.dcard_id.Enabled = True...
Hi, I have a macro that conditional formats a cell depending on the country it contains. What I need though is a way so that a particular colour scheme can apply to more than one country. So basically if A1 = "Sweden" "TRUE "FALSE" can become if A1= "Sweden" or "Ukraine" or "Barbados" "TRUE...
I am having a problem getting a worksheet change macro to run. I have range B1:B6 that is toggled between 1 and 2 by way of a radio button. The worksheet change macro runs fine if I manually input a value. And the macro I try to run through the worksheet change macro runs fine if I run it...
I have a line graph that can have a variable number (currently 31) of lines in it, some of which will be same colour. The macro currently reads:
' 1 - 5
.SeriesCollection(1).Format.Line.ForeColor.RGB = RGB(192, 192, 192)...