#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 161
Default 2 questions

I have two questions:
1. How do I identify a fill color for a cell so that I can match the text
to the color to hide it? Is there a beter way to hide the text so that it is
not visble?

2. A lot of times when I ask for help on a code, you use 'Me'. For example
'Me.commandbutton2.enabled = ok'. What is Me? I don't use it and it seems
to work fine.

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 247
Default 2 questions

1. How do I identify a fill color for a cell so that I can match the text
to the color to hide it? Is there a beter way to hide the text so that it
is
not visble?

record a macro while changing the color of the cell. it will then show the
number in the editor

2. A lot of times when I ask for help on a code, you use 'Me'. For example
'Me.commandbutton2.enabled = ok'. What is Me? I don't use it and it seems
to work fine.

the me points to the specific userform where the commandbutton2 is located.
could use userform1.commandbutton2.enabled = ok
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Answers to questions posing more questions in a workbook sbelle1 Excel Worksheet Functions 2 August 8th 09 01:02 AM
View Questions and Answer to questions I created Roibn Taylor Excel Discussion (Misc queries) 4 July 24th 08 12:05 AM
2 questions jkf New Users to Excel 2 November 2nd 06 08:58 PM
Max / IF questions G Excel Discussion (Misc queries) 1 October 12th 05 03:27 AM
add in questions keithb Excel Programming 1 August 17th 05 08:47 PM


All times are GMT +1. The time now is 01:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"