code is as follows:

Dim cbobox As Control

With ufrmRepoData
For Each cbobox In .Controls
If Right(cbobox.Name, 1) = 2 Then
If blnEnable Then cbobox.Interior.ColorIndex = vbWhite
End If
Next cbobox
End With

interior.colorindex doesnt work, how do I set the back colour via
code?
any help gratefully appreciated.
Matt.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=537170

Try:
If blnEnable Then cbobox.BackColor = vbWhite

hth

Geoff

"MattShoreson" wrote:


code is as follows:

Dim cbobox As Control

With ufrmRepoData
For Each cbobox In .Controls
If Right(cbobox.Name, 1) = 2 Then
If blnEnable Then cbobox.Interior.ColorIndex = vbWhite
End If
Next cbobox
End With

interior.colorindex doesnt work, how do I set the back colour via
code?
any help gratefully appreciated.
Matt.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=537170

Dim cbobox As Control

With ufrmRepoData
For Each cbobox In .Controls
If Right(cbobox.Name, 1) = 2 Then
If blnEnable Then cbobox.BackColor = vbWhite
End If
Next cbobox
End With


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MattShoreson"
wrote in message
news:MattShoreson.26z2kb_1146224102.9769@excelforu m-nospam.com...

code is as follows:

Dim cbobox As Control

With ufrmRepoData
For Each cbobox In .Controls
If Right(cbobox.Name, 1) = 2 Then
If blnEnable Then cbobox.Interior.ColorIndex = vbWhite
End If
Next cbobox
End With

interior.colorindex doesnt work, how do I set the back colour via
code?
any help gratefully appreciated.
Matt.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile:
http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=537170

I believe the phrase ' the answer's in the question' applies.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=537170

aah, but you mis-spelt it (or rather MS did) <G

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MattShoreson"
wrote in message
news:MattShoreson.26z76y_1146230101.1415@excelforu m-nospam.com...

I believe the phrase ' the answer's in the question' applies.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile:
http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=537170

I think it's a bug in their software.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=537170