0
   

HELP!!! I NEED EXCELL MACRO HELP!

Forums: Computers
Email this Topic • Print this Page
 
 
Flower
 
Reply Fri 13 Jun, 2003 08:18 am
Hi, I just found out about this site. I have a work project that I need help with. I am practicing with Macros in Excell (I know they are not called Macros, but you know what I mean). Can anyone tell me how to change the background color and text color with a macro?

I am using the record function to record replacing words with blank spaces. In some cases, the words that are deleted are in cell with reverse shading. When the words are deleted, I need the black background to be made white and the text to made black. Does this make any sense??
Any help would be appreciated
Thanks
Very Happy
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Discussion • Score: 0 • Views: 1,390 • Replies: 7
No top replies

 
owi
 
  1  
Reply Fri 13 Jun, 2003 09:17 am
Hello Flower, maybe this works:

"Selection.Font.ColorIndex = 1
Selection.Interior.ColorIndex = 2"
0 Replies
 
Flower
 
  1  
Reply Mon 16 Jun, 2003 08:16 am
Thanks, I'll try that.
0 Replies
 
Flower
 
  1  
Reply Mon 16 Jun, 2003 09:56 am
MORE EXCELL MACRO QUESTIONS
OK, another question. Is there a website that I can go to to get basic Macro instructions? My company does not office Macro training. Some stuff I am able to figure out on my own, but not everything. All of the Excell websites I go to seem to offer everything except beginning macro help.

Any suggestions???

Question
0 Replies
 
Butrflynet
 
  1  
Reply Mon 16 Jun, 2003 08:51 pm
Check out these sites...

Do a search on macros here http://www.mrexcel.com/index.html

http://www.er.uqam.ca/merlin/xw999998/eng/exlmac.htm
0 Replies
 
Mr Stillwater
 
  1  
Reply Mon 16 Jun, 2003 09:10 pm
What you need to do is 'switch' on the Formatting toolbar.

Goto: VIEW - TOOLBARS and click on FORMATTING (tick will appear)

Then you will have a range of options to modify the worksheet properties. There should be a bucket icon and a big A icon on the extreme right of the ribbon. Those are FILL colour (bucket) and TEXT colour (the big A). Highlight the cells you want to change and then click on the icon for colour choice.
0 Replies
 
Flower
 
  1  
Reply Tue 17 Jun, 2003 07:46 am
thanks!!
I will try the websites and the toolbar.

Thanks for all of your help!!

Laughing
0 Replies
 
Flower
 
  1  
Reply Tue 17 Jun, 2003 12:58 pm
I am getting there!! Now just need to find out if there is a way to search and replace font color and interior color. Is that possible? I am trying to find cells that have reverse print and change it to regular print.

As usual, any help would be very much appreciated!!

Thanks

Flower Very Happy
0 Replies
 
 

Related Topics

Super cool computer tricks, for dopes like me. - Discussion by OCCOM BILL
Clone of Micosoft Office - Question by Advocate
Do You Turn Off Your Computer at Night? - Discussion by Phoenix32890
The "Death" of the Computer Mouse - Discussion by Phoenix32890
Windows 10... - Discussion by Region Philbis
Surface Pro 3: What do you think? - Question by neologist
Windows 8 tips thread - Discussion by Wilso
Mac help/can't install new printer, don't remember passwd - Discussion by ossobuco
GOOGLE CHROME - Question by Setanta
.Net and Firefox... - Discussion by gungasnake
Hacking a computer and remote access - Discussion by trying2learn
 
  1. Forums
  2. » HELP!!! I NEED EXCELL MACRO HELP!
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 05/05/2024 at 02:39:50
▲ ▼