Thread: Spreadsheet in Userform
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
  
Posts: 1,549
Default Spreadsheet in Userform
Color requires a color value: vbBlue
ColorIndex requires an index: 41
--
Jim Cone
Portland, Oregon USA



"kalle"
wrote in message
Hi
-snip-
I have tried the following code but the cell or text will always be
black.

UserForm8.Spreadsheet1.Cells(1, 1).Interior.Color = 41
UserForm8.Spreadsheet1.Cells(1, 1).Font.Color = 41

I am grateful if someone can answer my questions.
Thanks in advance.
*** Sent via Developersdex http://www.developersdex.com ***
Reply With QuoteReply With Quote