$$Excel-Macros$$ listbox in excel that is an option for sql query

2008-09-25 Thread Laoballer
I have a set of data that looks like this STATE CITY OR Portland OR Beaverton WA Seattle WA Olympia WA Spokane CA Los Angeles CA San Diego CA San Jose What I would like to be able to do is have 3 list boxes, the fi

$$Excel-Macros$$ Re: Unable to open excel

2008-09-25 Thread AJIT NAVRE
Hi, The communication you are sending is ambiguous. THere are several reasons for getting this error message. And the reasons may vary from pivot tables, to linked formulas, or any add-in issues. To determine which of these is causing the error, please go to the below link: http://support.micros

$$Excel-Macros$$ Re: Excel Macros Book?

2008-09-25 Thread kalpesh velinkar
Dear John. Even I would like to learn. In case you find some solution without VBA. Please let me know. Kalpesh On Tue, Sep 16, 2008 at 7:11 PM, johnson dara <[EMAIL PROTECTED]> wrote: > Hi All, > > I would like to learn and start using macros as my daily life involves lot > of routine excel job

$$Excel-Macros$$ Re: change from small letter to capital

2008-09-25 Thread kalpesh velinkar
Hello Vinay. You can wirte the formula as per below. ab 1 kalpesh=upper(a1) Hope it solves your problem. On Sat, Sep 20, 2008 at 5:22 PM, vinay keni <[EMAIL PROTECTED]> wrote: > dear all, > > i want to know how to change from small letters to capital > letter

$$Excel-Macros$$ User restrictions in Excel

2008-09-25 Thread Hemant Kalia
Dear All i want to prepare an excel file with user restrictions - i found the following macro code on the net can anyone guide me Macro Name} User Specific Macro {Control Statement} IF {Condition} User = Shireen {Operator/function} USER( 'shireen' ) = 1 {Step} User Restriction - Shireen :(36 I

$$Excel-Macros$$ listbox in excel that is an option for sql query

2008-09-25 Thread Laoballer
I have a set of data that looks like this STATE CITY OR Portland OR Beaverton WA Seattle WA Olympia WA Spokane CA Los Angeles CA San Diego CA San Jose What I would like to be able to do is have 3 list boxes, the fi