PC Review


Reply
Thread Tools Rate Thread

Changing color

 
 
Robin
Guest
Posts: n/a
 
      25th Jun 2008
hello

i need help creating a macro that reads values from one sheet and
high-lights all the rows where the values appear in another sheet.

I have no idea on how i go about doing this, plz help!
 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      25th Jun 2008
Look at Find in VBA Help.

--
__________________________________
HTH

Bob

"Robin" <(E-Mail Removed)> wrote in message
news:87856347-9945-45CB-AAF2-(E-Mail Removed)...
> hello
>
> i need help creating a macro that reads values from one sheet and
> high-lights all the rows where the values appear in another sheet.
>
> I have no idea on how i go about doing this, plz help!



 
Reply With Quote
 
Robin
Guest
Posts: n/a
 
      25th Jun 2008
erm sorry could u plz tell me where is VBA Help?

Thanks and Regards
Robin

"Bob Phillips" wrote:

> Look at Find in VBA Help.
>
> --
> __________________________________
> HTH
>
> Bob
>
> "Robin" <(E-Mail Removed)> wrote in message
> news:87856347-9945-45CB-AAF2-(E-Mail Removed)...
> > hello
> >
> > i need help creating a macro that reads values from one sheet and
> > high-lights all the rows where the values appear in another sheet.
> >
> > I have no idea on how i go about doing this, plz help!

>
>
>

 
Reply With Quote
 
Bob Phillips
Guest
Posts: n/a
 
      25th Jun 2008
You are creating macros and you haven't discovered VBA Help?

F1 in the VBIDE.

--
__________________________________
HTH

Bob

"Robin" <(E-Mail Removed)> wrote in message
news:2D062B22-92D7-41C5-896A-(E-Mail Removed)...
> erm sorry could u plz tell me where is VBA Help?
>
> Thanks and Regards
> Robin
>
> "Bob Phillips" wrote:
>
>> Look at Find in VBA Help.
>>
>> --
>> __________________________________
>> HTH
>>
>> Bob
>>
>> "Robin" <(E-Mail Removed)> wrote in message
>> news:87856347-9945-45CB-AAF2-(E-Mail Removed)...
>> > hello
>> >
>> > i need help creating a macro that reads values from one sheet and
>> > high-lights all the rows where the values appear in another sheet.
>> >
>> > I have no idea on how i go about doing this, plz help!

>>
>>
>>



 
Reply With Quote
 
Robin
Guest
Posts: n/a
 
      25th Jun 2008
thanks i found it :-)

"Bob Phillips" wrote:

> You are creating macros and you haven't discovered VBA Help?
>
> F1 in the VBIDE.
>
> --
> __________________________________
> HTH
>
> Bob
>
> "Robin" <(E-Mail Removed)> wrote in message
> news:2D062B22-92D7-41C5-896A-(E-Mail Removed)...
> > erm sorry could u plz tell me where is VBA Help?
> >
> > Thanks and Regards
> > Robin
> >
> > "Bob Phillips" wrote:
> >
> >> Look at Find in VBA Help.
> >>
> >> --
> >> __________________________________
> >> HTH
> >>
> >> Bob
> >>
> >> "Robin" <(E-Mail Removed)> wrote in message
> >> news:87856347-9945-45CB-AAF2-(E-Mail Removed)...
> >> > hello
> >> >
> >> > i need help creating a macro that reads values from one sheet and
> >> > high-lights all the rows where the values appear in another sheet.
> >> >
> >> > I have no idea on how i go about doing this, plz help!
> >>
> >>
> >>

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing text color and textbox color on Access Report Cindy Microsoft Access Reports 0 1st Dec 2010 05:15 PM
Can you vary the strikethrough color without changing text color Linmark10 Microsoft Word Document Management 2 16th Dec 2008 12:22 AM
changing a color based on another color change Steve Microsoft Excel Programming 1 25th Nov 2008 12:05 PM
Changing color in color palette Gilbert De Ceulaer Microsoft Excel Setup 1 12th Dec 2004 02:39 PM
Changing Application color to follow Change of System Color Toni Microsoft Dot NET Framework Forms 2 11th May 2004 10:15 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:16 PM.