![]() |
#1
|
|||
|
|||
![]() 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. |
#2
|
||||
|
||||
![]()
Use Alt & F11 to see the Visual Basic window.
Cheers, |
#3
|
||||
|
||||
![]()
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.
|
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
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 |
![]() |
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 |