$$Excel-Macros$$ Re: Excel 2002 Forms toolbar

How did you solve it?? Regards, Andy On Mon, Aug 24, 2009 at 8:39 AM, Tommy wrote: > > SOLVED > > On Aug 21, 10:58 am, Tommy wrote: > > When I bring up the Forms toolbar there are some controls that are > > grayed out, specifically the Dropdown List and some others. Can anyone > > shed any lig

$$Excel-Macros$$ How to plus two textboxes in currency and with 2 decimals

Hey out there, First of all, a big thank you to all the MS Excel experts out there, sharing there knowledge at no cost at all in this forum. Secondly, my question. The subject title, actually says it all. My goal is to calculate the currency contents within two textboxes. The result should be

$$Excel-Macros$$ Re: Help for Hlookup using if function

Hi Mahesh, Please find the attach sheet with correct formula. Hope it will help you. Rgds, Mahender Bisht On Sun, Aug 23, 2009 at 10:51 AM, mahesh parab wrote: > Dear All > > In attach sheet i am getting error in hlookup if i use if condition, please > assist. > > > > > > > -- With Love, Ma

$$Excel-Macros$$ Re: Excel 2002 Forms toolbar

SOLVED On Aug 21, 10:58 am, Tommy wrote: > When I bring up the Forms toolbar there are some controls that are > grayed out, specifically the Dropdown List and some others. Can anyone > shed any light on this. I am trying to construct a form and the > Dropdown List control would be needed. Any he

Re: Fw: $$Excel-Macros$$ V look within a specific range based on criteria

On Sun, Aug 23, 2009 at 7:47 PM, Sandeep wrote: > Hi Prashant, > > I don't know any perticular way for any kind of formula. I just try to > use all related concepts I know, to solve problems. > > Regards > Sandeep > > - Original Message - > *From:* Prashant Bhawar > *To:* excel-macros@g

$$Excel-Macros$$ Drop-down Box display

I would like to be able to clear, or return to a desired state such as “Enter xxx” the window of a drop-down box in preperation for making a new selection.. Is this possible? What statement(s) might I use? Any help would be welcom. Tommy --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Sharing -loss of data - even though 1 user per sheet

Please help On Aug 20, 3:12 pm, "melissa.brown" wrote: > I've shared it as example.xls > > On Aug 19, 3:55 pm, venkatesh wrote: > > > > > Hi Mel! > > > can you please share the worksheet for better understanding. > > > Venky > > > On Aug 19, 10:18 am, "melissa.brown" > > wrote: > > > > Hi Ever

$$Excel-Macros$$ Re: Need Urgent help in finding formula.

You're welcome. Dave. From: sandymau...@gmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Need Urgent help in finding formula. Date: Sat, 22 Aug 2009 23:43:27 +0530 Hi Dave, Thank you for this great information. These kind of things are not available in many boo

Re: Fw: $$Excel-Macros$$ V look within a specific range based on criteria

Hi Prashant, I don't know any perticular way for any kind of formula. I just try to use all related concepts I know, to solve problems. Regards Sandeep - Original Message - From: Prashant Bhawar To: excel-macros@googlegroups.com Sent: Sunday, August 23, 2009 7:16 PM Subject:

Re: Fw: $$Excel-Macros$$ V look within a specific range based on criteria

On Sat, Aug 22, 2009 at 11:40 PM, Sandeep wrote: > Hi Subu > Sorry I forgot to attach file. > > Find the attach file which produce the result of VOOKUPIF ( ) function. Be > careful about the conditions for the formula if you want correct result. > > Sandeep > > - Original Message - > *Fr

$$Excel-Macros$$ Re: Imp - Add

=sum(cell1:cell2) On Sun, Aug 23, 2009 at 9:06 AM, Tolontino Gomes < tolontino.go...@pepsidrc.ae> wrote: > > > *Dear,* > > * * > > *What formula do you use for adding values please reply* > > * * > > * * > > * * > > * * > > > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@goo

$$Excel-Macros$$ Re: Please Help Me!!!***Solved***

Hi Everyone, I solved my problem of ranking. Here is attach solution Thanks Everyone for helping me. Specially Dave I thanks you ( I used -- operator to solve this problem without vba). Thanks & Regards Sandeep - Original Message - From: Sandeep To: excel-macros@googlegroups.com

$$Excel-Macros$$ Re: Help for Hlookup using if function

Hi Mahesh, Kindly find the attached solution in the mail. Thanks & Regards, Ramkrishna T. Padhi On Sun, Aug 23, 2009 at 10:51 AM, mahesh parab wrote: > Dear All > > In attach sheet i am getting error in hlookup if i use if condition, please > assist. > > > > > > > --~--~-~--~~

$$Excel-Macros$$ Re: Help for Hlookup using if function

Dear TEam Its a small mistake you have done a wrong bracket is used, i have rectified regards Vijay On Sun, Aug 23, 2009 at 10:51 AM, mahesh parab wrote: > Dear All > > In attach sheet i am getting error in hlookup if i use if condition, please > assist. > > > > > > > -- Thanks Vijay Togaru

$$Excel-Macros$$ Re: Help for Hlookup using if function

- Original Message - From: mahesh parab To: excel-macros@googlegroups.com Sent: Sunday, August 23, 2009 10:51 AM Subject: $$Excel-Macros$$ Help for Hlookup using if function Dear All In attach sheet i am getting error in hlookup if i use if condition, please assist.

$$Excel-Macros$$ Re: Dynamic Menu Creation - EVent bassd

Hi Kasmal, You can hide and unhide the menu for any worksheet with this code in the worksheet events "Activate" and "Deactivate": Private Sub Worksheet_Activate() 'To hide Application.CommandBars("Your custom menu Name").Enabled = False End Sub Private Sub Worksheet_Deactivate() 'To unhide

$$Excel-Macros$$ Re: Help for Hlookup using if function

Done...see attached file On Sun, Aug 23, 2009 at 10:51 AM, mahesh parab wrote: > Dear All > > In attach sheet i am getting error in hlookup if i use if condition, please > assist. > > > > > > > -- Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~-~--~~