$$Excel-Macros$$ doubt with setfocus

Dear Experts I am enclosing the attachment which was solved by NOORAIN. but when I add third textbox to the userform, the code is not working. Please guide me. regards shankar sb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread tit

RE: $$Excel-Macros$$ doubt with setfocus

Hello Shankar, The code in your userform detects when TextBox2 gets the focus and displays a message before using SetFocus to return to TextBox1. Since the code is in an "event" procedure for TextBox2, it only executes when the user tries to enter TextBox2 -- not when they try to enter TextBox3 o

$$Excel-Macros$$ Forgot my workbook encrypted password

Hi Experts I forgot my workbook encrypted password can you help me how to remove or view that data, In that i don't Put a read only check mark also help me plzzz as soon as possible -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor t

RE: $$Excel-Macros$$ Forgot my workbook encrypted password

Hi Renukachari, Sorry, your query is against group rules. "3) Don't post questions regarding breaking or bypassing any security measure." is stated at the bottom of every message and on the website. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of R

Re: $$Excel-Macros$$ is ther any way to keep subject line while opening outlook new mail

Hi Renuka, Try it.. =HYPERLINK("mailto:"&G2&"?bcc=noorain.ans...@gmail.com&Subject=Ladger statement",G2) -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Tue, Feb 21, 2012 at 11:33 AM, renuka chari

Re: $$Excel-Macros$$ is ther any way to keep subject line while opening outlook new mail

For advance Hyperlink, You can visit on.. http://datapigtechnologies.com/blog/index.php/emailing-from-excel-using-the-hyperlink-function/ -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Tue, Feb 21,

$$Excel-Macros$$ Remove me from the group

Hi Admin, Please remove me from the group. regards On Tue, Feb 21, 2012 at 11:33 AM, renuka chari wrote: > hi > Noorain > > i know that formula, but i neet To Address,bcc Address & Subject. At > a Single glance > > > > thanks > > > > > > > > On Feb 19, 11:34 am, NOORAIN ANSARI wrote: > > De

Re: $$Excel-Macros$$ is ther any way to keep subject line while opening outlook new mail

hi Noorain thanks a lot. i am expecting Ans like this only On Feb 21, 3:58 pm, NOORAIN ANSARI wrote: > For advance Hyperlink, You can visit > on..http://datapigtechnologies.com/blog/index.php/emailing-from-excel-usi... > -- > Thanks & regards, > Noorain Ansari >  *http://noorainansa

Re: $$Excel-Macros$$ Forgot my workbook encrypted password

Hi Alll i am extremely Sorry for that On Feb 21, 2:46 pm, "Asa Rossoff" wrote: > Hi Renukachari, > > Sorry, your query is against group rules.  "3) Don't post questions > regarding breaking or bypassing any security measure." is stated at the > bottom of every message and on the website. > > Asa

Re: $$Excel-Macros$$ Remove me from the group

Dear Raja, http://groups.google.com/group/excel-macros/subscribe click on unsubscribe On Tue, Feb 21, 2012 at 6:14 PM, RAJA SHEKAR wrote: > Hi Admin, > > Please remove me from the group. > > regards > > On Tue, Feb 21, 2012 at 11:33 AM, renuka chari wrote: > >> hi >> Noorain >> >> i know that

Re: $$Excel-Macros$$ Forgot my workbook encrypted password

Please attached file to remove password see: https://sites.google.com/site/chilexcel/desbloqueos-y-removepass Chilexcel 2012/2/21 renuka chari > Hi Alll > i am extremely Sorry for that > > On Feb 21, 2:46 pm, "Asa Rossoff" wrote: > > Hi Renukachari, > > > > Sorry, your query is against g

Re: $$Excel-Macros$$ Forgot my workbook encrypted password

Respecting the rules of the group .. and only One Time and thinking it to good use Please attach a file to remove password see: https://sites.google.com/site/chilexcel/desbloqueos-y-removepass Chilexcel 2012/2/21 ChilExcel > Please attached file to remove password > > se

$$Excel-Macros$$ How to modify code to display .PDF & .TIF file types as hyperlinks in Excel 2010 instead of just .PDF files.

Hi, I have the following code which searches a folder and than displays all the .PDF files as hyperlinks in the body of the Excel spreadhsheet. I want to modify it so that it can display .TIF files also. Can you please look at the code below and see if this can be done. All help is appreciated. P

Re: $$Excel-Macros$$ Help with code please.

This will look in all sheets in the file and select if found. Put it in your DIR loop for all files in the folder. Sub lookinallsheets() For Each ws In Worksheets With ws Set mf = .Cells.Find(What:="whattolookfor", LookIn:=xlValues, _ LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNe

Re: $$Excel-Macros$$ How to modify code to display .PDF & .TIF file types as hyperlinks in Excel 2010 instead of just .PDF files.

I would probably write this differently but try this If Right(f.Name, 4) = ".pdf" ORIf Right(f.Name, 4) = ".tif" Then Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Dave Sent: Tuesday, February 21, 2012 8:26 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel

Re: $$Excel-Macros$$ List Box Like Tally Software

hi exell famly can any one give my logic code if possible, please... chandru On Mon, Feb 20, 2012 at 10:18 PM, chandra sekaran wrote: > Dear Maries , > > First of i would thanks for valuable effort , but what i expected like > this only if Activate D1 Cell then Immdiataly like below

Re: $$Excel-Macros$$ How to modify code to display .PDF & .TIF file types as hyperlinks in Excel 2010 instead of just .PDF files.

Thanks Don I tried it and its giving me a Syntax error. here is the line as I have it in the code. If Right(f.Name, 4) = ".pdf" OR If Right(f.Name, 4) = ".tif" Then On Feb 21, 8:37 am, "dguillett1" wrote: > I would probably write this differently but try this > > If Right(f.Name, 4) = ".pdf" OR

Re: $$Excel-Macros$$ How to modify code to display .PDF & .TIF file types as hyperlinks in Excel 2010 instead of just .PDF files.

If Right(f.Name, 4) = ".pdf" OR If Right(f.Name, 4) = ".tif" Then do not use ( OR If ) *try this * If Right(f.Name, 4) = ".pdf" OR Right(f.Name, 4) = ".tif" Then Download Free Excel Addin On Tue, Feb 21, 2012 at 8:37 P

$$Excel-Macros$$ Excel Addin

Hi group Please try the updated add-in. Its free . Hope you will like it http://www.excelvbamacros.com/2012/01/my-menu-functions-and-help.html -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printin

Re: $$Excel-Macros$$ Excel Addin

*Thank you so much Ashish... It is working well in 2010. * On Tue, Feb 21, 2012 at 8:31 PM, ashish koul wrote: > Hi group > > Please try the updated add-in. Its free . Hope you will like it > > http://www.excelvbamacros.com/2012/01/my-menu-functions-and-help.html > > -- > *Regards* > * * > *As

Re: $$Excel-Macros$$ How to modify code to display .PDF & .TIF file types as hyperlinks in Excel 2010 instead of just .PDF files.

Here's a more cleaner code Dim objFSO As Object 'FileSystemObject Sub ExampleSub() Dim obj As Object 'Folder Set objFSO = CreateObject("Scripting.FileSystemObject") Set obj = objFSO.GetFolder("C:\Folder") FolderRead obj End Sub Private Sub FolderRead(ByRef myFolder) Dim ob

Re: $$Excel-Macros$$ Excel Addin

Ashish Can u pls give instructions on how to use this On Feb 21, 2012, at 11:31 AM, ashish koul wrote: > Hi group > > Please try the updated add-in. Its free . Hope you will like it > > http://www.excelvbamacros.com/2012/01/my-menu-functions-and-help.html > > -- > Regards > > Ashish

Re: $$Excel-Macros$$ How to modify code to display .PDF & .TIF file types as hyperlinks in Excel 2010 instead of just .PDF files.

Thank Ashish & Don for saving the day & my hide!! On Feb 21, 10:27 am, ashish koul wrote: > If Right(f.Name, 4) = ".pdf" OR If  Right(f.Name, 4) = ".tif" Then  do not > use ( OR If ) > > *try this * > > If Right(f.Name, 4) = ".pdf" OR   Right(f.Name, 4) = ".tif" Then > > Download Free Excel > Add

Re: $$Excel-Macros$$ Help with code please.

You'd want to exit the routine if the cell is found. Also, you can use application.goto to select the cell. I would also be weary about hidden sheets if any. Sub lookinallsheets() Dim wks As Worksheet Dim rng As Range For Each wks In Worksheets With wks Set rng = .

Re: $$Excel-Macros$$ List Box Like Tally Software

hi Sam, when i type D1 cell customer name below data coming very perfect but if type D1 cell fist i donot know the Customer name when i D1 Cell Activate then list of Customer name populate after that if type first letter like " L " then in my Customer list start with L will shown like tha

Re: $$Excel-Macros$$ List Box Like Tally Software

Boss, if you type L, all the customers starting with L is listed in the table below. Then why do you need a separate list in D1? On Tue, Feb 21, 2012 at 11:37 PM, chandra sekaran wrote: > > hi Sam, > > when i type D1 cell customer name below data coming very perfect but if > type D1 cell fist

$$Excel-Macros$$ Shotcut Security Warning

Hi All I have a macro that runs correctly when started from the "Macros" button on the developer tab, but fails with a security warning when run from its shortcut "Ctrl-U". Anyone got any thoughts? Thanks James -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accura

Re: $$Excel-Macros$$ List Box Like Tally Software

Hi Chandru, If you want list box, only two option in Excel like Data Validation, Combo Box. But both options, after selection only data will apply in cell value. Hence, there is no chance compare with database when typing or partial string. I hope this clarify clear. Dear Group Friends, If you

Re: $$Excel-Macros$$ List Box Like Tally Software

Making Combo Box: http://www.screencast.com/t/69UdkpgmFv On Tue, Feb 21, 2012 at 10:34 PM, Maries wrote: > Hi Chandru, > > If you want list box, only two option in Excel like Data Validation, Combo > Box. > > But both options, after selection only data will apply in cell value. > > Hence, there

Re: $$Excel-Macros$$ Shotcut Security Warning

*Please share your file or VBA codes...* On Tue, Feb 21, 2012 at 5:01 PM, James McGinty wrote: > Hi All > > I have a macro that runs correctly when started from the "Macros" > button on the developer tab, but fails with a security warning when > run from its shortcut "Ctrl-U". Anyone got any th

Re: $$Excel-Macros$$ Help plz

=IF(AND(A1>=3000,A1<=4500),B1*0.5,B1) Sam Mathai Chacko On Tue, Feb 21, 2012 at 2:01 PM, m7md.gmail wrote: > Please check attached > I need this function necessary now . > > thanks, > > > * > -- > * > > Regards, > > Mohamed Mahmoud > > > > > -- > FORUM RULES (986+

Re: $$Excel-Macros$$ List Box Like Tally Software

Dear Maries & SAM Lot of Thanks Providing such a wonderful coding part, i understand form you, Once again Thanking all Have a Good day for you Regards chandru On Wed, Feb 22, 2012 at 12:05 AM, Maries wrote: > Making Combo Box: > > http://www.screencast.com/t/69UdkpgmFv > > > On Tue,

Re: $$Excel-Macros$$ Help plz

Try it in C1, =IF(AND(A1>3000,A1<4500),B1*0.5,"") If A1 is not in between 3000 and 4500, nothing will show. On Tue, Feb 21, 2012 at 12:31 PM, m7md.gmail wrote: > Please check attached > I need this function necessary now . > > thanks, > > > * > -- > * > > Regard

Re: $$Excel-Macros$$ how to find a text in a folder

hi, This is working fine for searching text, how to search for numbers sir, means example if i want search a invoce number 2000127845 in a folder in which there are 50 files. Thank you with regards raghu On Mon, Feb 20, 2012 at 11:47 PM, raghu gr wrote: > > hi, > > Thanks this is very good.

Re: $$Excel-Macros$$ search via macro like excel

> > ** > > 2012/2/21 Maries > Hi Prajakt, > > Please find the attached file.I have used below codes in user form. > > Private Sub CommandButton1_Click() > > Dim rng1 As Range > Dim lll As Integer > > Sheets("Sheet2").Select > Cells.Select > Selection.ClearContents > > lll = Len(Te

Re: $$Excel-Macros$$ Help with code please.

Sam, The code I provided does stop the macro with the selection. Yes, goto could be used but OP said select sheet select cell so I did that. “6 of one is 1/2 dozen of another” Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Tuesday, February 21, 2012 11:39 AM

RE: $$Excel-Macros$$ Help with code please.

Too true Don// .Find finds the first match. and stops. However, with all the undue attention to this code, I will offer a suggested update. The Set mg = .Cells.Find lines can be changed to the following to prevent an oft-overlooked issue with .Find. The issue is that .Find does not start

RE: $$Excel-Macros$$ Help with code please.

Somehow got and extra quote and comma there.. strange; this should be right: Set mf = .Cells.Find(What:="whattolookfor", After:=.Cells(.Rows.Count, .Columns.Count), LookIn:=xlValues, _ LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext) From: Asa Rossoff [mailto:a...@lovetour

Re: $$Excel-Macros$$ Help with code please.

Asa, Agree about the “undue attention”. My experience tells me that just leaving it out ( as I did) serves the purpose. Maybe you can time it.?? Don Guillett SalesAid Software dguille...@gmail.com From: Asa Rossoff Sent: Tuesday, February 21, 2012 2:10 PM To: excel-macros@googlegroups.com Subj

Re: $$Excel-Macros$$ Help with code please.

Haha, I like the way you put that Don. I agree 6 of 1 is half a dozen of another. On the other point however, I am afraid I have to disagree. If the workbook has the text you are looking for in more than one sheet, the code will go forward and the last sheet that has the word being looked for will

Re: $$Excel-Macros$$ Help with code please.

Computer is tired and going to be early but after I asked the same question the OP said “ There will never be more than 1 of the same number. I just need it to > select the sheet that it's on and then select the cell where it's located.” Pls test what I provided. Don Guillett SalesAid Software

Re: $$Excel-Macros$$ Help with code please.

Don, your code works fine for the selection. I would gladly accept any correction if somebody did that to me. My only point is that 1. Find doesn't stop the loop in other words, the loop will need to be exited. If you have many sheets and the word you are looking for is in the first sheet itself,

FW: $$Excel-Macros$$ macro to sort excel data & email to party

Dear All, Please find attached sample file. Following things needs to be done; 1) In first sheet there are data that needs to be sorted work shop wise. 2) In the second sheet email ids are mentioned where we need to send those sorted data per workshop. Please let me know if we have

$$Excel-Macros$$ Rounding Numbers

Dear Experts, Good Noon. Need help on rounding up of numbers based on the decimal through a formula... the criteria for roudning is : a) Less than or equal to 0.5 should get round down to preceeding multiple of Ten (10.1 to 10.5 should be rounded to 10) b) Greater than or equal to 0.6 should g

Re: $$Excel-Macros$$ Rounding Numbers

Dear jayaprakash s, You can use the below mentioned formula ROUND(A1,-0.2) sanjib On Wed, Feb 22, 2012 at 1:04 PM, Jayaprakash S wrote: > Dear Experts, > > Good Noon. > > Need help on rounding up of numbers based on the decimal through a > formula... > > the criteria for roudning is : > > a) L