Re: $$Excel-Macros$$ Re: AssignMacro to Shape - for a Userform

cool .. Cheers!! ᐧ On Mon, Jan 19, 2015 at 2:33 AM, sswcharlie wrote: > Hi Guys > > > Thanks for your replies. All sorted now. > > Charlie > > On Sunday, January 18, 2015 at 6:28:38 PM UTC+13, sswcharlie wrote: >> >> Hi >> >> Trying to get a macro assigned to open a userform. The macro does n

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

Thanks Vaibhav Bhai!!! Regards Ashish -- 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 titl

$$Excel-Macros$$ Re: sum values with col/row criteria

File attached to try to be more clear on what I'm trying to do. -- 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 titl

$$Excel-Macros$$ Re: AssignMacro to Shape - for a Userform

Hi Guys Thanks for your replies. All sorted now. Charlie On Sunday, January 18, 2015 at 6:28:38 PM UTC+13, sswcharlie wrote: > > Hi > > Trying to get a macro assigned to open a userform. The macro does not > show in Macro Menu. Have tried some VBA in 'Workbook' visual. (off the > net) > >

Re: $$Excel-Macros$$ AssignMacro to Shape - for a Userform

hi you want to show UserForm1, however pl check actual name of form! This could be UserForm insted of UserForm1 or something else.. Cheers!! On Sun, Jan 18, 2015 at 10:58 AM, sswcharlie wrote: > Hi > > Trying to get a macro assigned to open a userform. The macro does not > show in Macro Menu.

Re: $$Excel-Macros$$ sum values with col/row criteria

hi can you share an excel sheet with example with little more explanation on how you arrived to result.. Cheers!! On Sat, Jan 17, 2015 at 3:09 PM, MLT wrote: > Here's one: > > In A1:A7: > 1st > 3rd > 1st > 2nd > 3rd > > In B1:E1: 3, 2, 5, 4 > > In C4: cat > In E7: dog > > I want to make a form

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

Good one ashish bhai, i remeber this you posted long ago too... On Sun, Jan 18, 2015 at 9:16 AM, Ashish Bhalara wrote: > Thanks Mr.Ashish Kumar, your sharing file of ListPicker is very useful for > me. :) > > Regards. > Ashish Bhalara > 9624111822 > P*Please do not print this email unless it is

Re: $$Excel-Macros$$ VBA help required for specific Output from Input

Sach, Amended code to suits your need.. Cheers!! On Fri, Jan 16, 2015 at 5:28 PM, sach so wrote: > Dear Expert, > > I required some changes in VBA, file attached here. I have data sheet, > for Input i have input sheet & for output have output sheet. when I run > macro i will get output. > > *

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

Welcome. Regards Ashish -- 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, like Please Hel

Re: $$Excel-Macros$$ Problem Autofilter Date Range

Change this line to FDate = Range("J1")x1 Ldate = Range("J2")x1 Cheers! ! On Jan 18, 2015 3:31 PM, "Ashish Bhalara" wrote: > Dear experts, > > I want automatic filtering of Date range in cell C11 but the below code is > not work for Date Field, the output is hide to all data. Please sugg

$$Excel-Macros$$ Re: VBA help required for specific Output from Input

Please any one do the needful. Regards, Sachin On Friday, January 16, 2015 at 5:28:45 PM UTC+5:30, sach so wrote: > > Dear Expert, > > I required some changes in VBA, file attached here. I have data sheet, > for Input i have input sheet & for output have output sheet. when I run > macro i will

$$Excel-Macros$$ Problem Autofilter Date Range

Dear experts, I want automatic filtering of Date range in cell C11 but the below code is not work for Date Field, the output is hide to all data. Please suggest what are mistake in coding. Sub Custom2() Dim r As String Dim FDate As Date, Ldate As Date r = Range("j3").Value Ran

Re: $$Excel-Macros$$ AssignMacro to Shape - for a Userform

You put the code in the module 2015-01-18 12:28 GMT+07:00 sswcharlie : > Hi > > Trying to get a macro assigned to open a userform. The macro does not > show in Macro Menu. Have tried some VBA in 'Workbook' visual. (off the > net) > > Sub... > UserForm1.Show > EndSub > > but userform still does