Re: $$Excel-Macros$$ cell tooltip

Dear Abhishek, I have database for medicines, that data base have columns call side effect and contraindications value of both columns are like five to six line paragraph. If I want to see this side effect and contraindications, I need to press F2, it will visible like paragraph, so each time or

Re: $$Excel-Macros$$ How to copy a series of ranges from one worksheet to another

DP, Sorry I didn't respond soonerthank you for you direction...much appreciated Rob On Thu, Feb 20, 2014 at 6:11 PM, De Premor wrote: > Hi Rob, > > Try this 2 code, first sub code just need a few line code, but it slower > than next sub code, i suggest second sub code if you have large d

$$Excel-Macros$$ Re: How to recover the password protected XL file

Hi, Perfect data solutions Thanks, you -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles,

$$Excel-Macros$$ Help me for interview : Excel Formulas and Macros

Dear Friends, I have scheduled for an Interview on coming Monday. Please help in what are basic things that could be prepared in Excel formulas and Macros. Particularly i'm very new to macro, so what are the basic syntax commonly used. Send me files with basic macro project. Please guide me. T

$$Excel-Macros$$ Re: Command Buttons in excel (office360)

I think I've figured out a partial answer by searching other boards and some tinkering. Apparently command buttons are now one of several shapes on the sheet. They seem to no longer have the ability to be disabled, but can be made visible/invisible (almost as good). The code below inserted o

$$Excel-Macros$$ Re: VBA macros and Windows OS language

Hi Aashish, I cannot address your question directly, but I have a suggestion for you and any programmer who is forcing users to login a second time to use their file. Make it easier on your users by leveraging their OS login session for identification instead. The following simple lines r

Re: $$Excel-Macros$$ Link Custom Toolbar with a file

I have several Excel workbooks that have custom Tool Bars. In Excel 2010, they decided that custom toolbars need to be in "Add-Ins", which, in my opinion, was a poor decision.   What I use is:   I created a macro called New_CmdBar in which I define the toolbar (called "PMTR").   Then, in the ThisW

Re: $$Excel-Macros$$ cell tooltip

Just to help me understand: Why do you want to reflect the value in tooltip when it is already visible in the Cell itself? Do you mean Cell Address instead of Cell Value? Example - Cell Value is "Rupesh" Cell Address is "E2" What do you want to appear in the tool tip? On Fri, Mar 7, 2014 at

Re: $$Excel-Macros$$ cell tooltip

Hi Expert, Is there no way to do that? On Fri, Mar 7, 2014 at 9:57 AM, Rupesh Patil wrote: > Hi Expert, > > I need your help. how to show cell value as tool tip when mouse over that > cell. > > -- > Thanks and Regards, Rp. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wann

$$Excel-Macros$$ Help me in Dashboard

Hi, Am trying to do dashboard here If I click on Radio button automatically graph need to get change. Could you please help me on this. Thanks, Chandru -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum

Re: $$Excel-Macros$$ Name Range Change through VBA

try this, Sub namerange() Dim rngRange As Range Dim rngCell As Range Set rngRange = Application.InputBox("select range", , , , , , , 8) For Each rngCell In rngRange.Columns(1).Cells ThisWorkbook.Names.Add rngCell, rngCell.Offset(, 1).Formula Next End Sub On Thu, Mar 6, 2014 at 11:24 PM, Pr

Re: $$Excel-Macros$$ Link Custom Toolbar with a file

Can you share the module or AddIn? On Fri, Mar 7, 2014 at 1:39 PM, wrote: > Thanks Clive but iy didn't help. > What I guess I'm looking for is an event that is triggered when a > programme is brought back to the full page state from the diminished state > on the Task Bar. > donwb > > > On Tuesd

Re: $$Excel-Macros$$ Link Custom Toolbar with a file

Thanks Clive but iy didn't help. What I guess I'm looking for is an event that is triggered when a programme is brought back to the full page state from the diminished state on the Task Bar. donwb On Tuesday, 4 March 2014 18:40:43 UTC, clive r wrote: > You could MAYBE try "RECORD MACRO" to

Re: $$Excel-Macros$$ Re: "Two-dimensional" interpolation

Well, spotted, thanks On Thursday, 6 March 2014 13:37:10 UTC+2, Paul Schreiner wrote: > The problem seemt to be: > > in LinInterpolate, xRange and yRange are declared as "variant" > when you pass xRange as Range("B3:B44").Value, > you're passing an ARRAY, so xRange becomes an Array variable. >