Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-03-2010, 09:37 AM
shakilhyd shakilhyd is offline VB Code in Excel Active worksheet Windows XP VB Code in Excel Active worksheet Office 2003
Novice
VB Code in Excel Active worksheet
 
Join Date: May 2010
Posts: 1
shakilhyd is on a distinguished road
Default VB Code in Excel Active worksheet


Hello, How I can write VB Code in Excel sheet. I want to write VB code in my worksheet.
Logic is that when I change tab the backgroup color should become 'RED' and fot color should become 'WHITE'
Means the current tab's the backgroup color should become 'RED' and fot color should become 'WHITE'.
Please advise how can I write the code and how I can save and run. Help please. Thanks.
Reply With Quote
  #2  
Old 05-03-2010, 02:35 PM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline VB Code in Excel Active worksheet Windows XP VB Code in Excel Active worksheet Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

Use Alt & F11 to see the Visual Basic window.

Cheers,
Reply With Quote
  #3  
Old 05-17-2010, 07:50 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline VB Code in Excel Active worksheet Windows 7 VB Code in Excel Active worksheet Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

If you create a macro - THEN use Alt+F11 you will then see the macro as VBA. Doing it this way, you can learn the basics of VBA.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Code for making "mailings" tab active jandrade15 Mail Merge 0 08-01-2009 09:20 PM
Excel ->VB code for Checkbox (control toolbox) kirkstyle Excel 0 08-16-2006 04:17 PM
Active Directory nukkumatti Misc 0 11-16-2005 08:42 AM
VB Code in Excel Active worksheet mail receipent with an excel worksheet attachment jburke@holidayinnislip.co Office 1 11-14-2005 08:55 AM
Delete excel files by code in Access Barry Richardson Office 0 06-13-2005 06:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft