Re: $$Excel-Macros$$ VBA select data in BOLD

Hi Don Thanks for code. Wow it works great and fast. In the line of code that puts the info into col H , how do I put into 3 different colums ? Say H, I, J. I could run text to columns on the result but would prefer to do it with code Thanks Charlie On Fri, Dec 16, 2011 at 1:56 PM, dguill

Re: $$Excel-Macros$$ I want to do or learn VBA coding and MACRO

thanx     From: Waseem Saifi To: excel-macros@googlegroups.com Sent: Thursday, 15 December 2011 2:54 PM Subject: Re: $$Excel-Macros$$ I want to do or learn VBA coding and MACRO Hi Laxman,       there is a book by named "Excel 2010 power programming with vba"

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

Hi, Please find attached sample file. regards, vickey -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or

$$Excel-Macros$$ Re: how to formatting the vba code using Notepad ++,can anyone help me?

Rohan, Kindly thanks,you give me many help. Best wishs to you Garcia On 12月16日, 上午2时34分, Rohan wrote: > Hi, > > Choose the language that you are using from the toolbar - language > menu. > > There is a specific format for each specific language there. Hence, as > you choose VBA, and paste in y

Re: $$Excel-Macros$$ VBA select data in BOLD

One way Option Explicit Sub foreachcoSAS() Dim lr As Long Dim i As Long Dim ph As Long Dim em As Long Dim c As Range Dim ms As String i = 1 lr = Cells(Rows.Count, "g").End(xlUp).Row For Each c In Range("g1:g" & lr) If c.Font.Bold Then 'MsgBox c ph = Columns("g").Find(What:="ph", After:=Cells(i,

$$Excel-Macros$$ VBA select data in BOLD

Hi Have addresses like this: (columnG) ABC COMPANY 123 Delta St Town Ph 0800123456 fax 234567 email1...@dfg.com Sometimes there are more rows with irrelvant informtation I want to select 3 of the rows : ABC COMPANY Ph 0800123456 email 1...@dfg.com And place them in a single row i

$$Excel-Macros$$ Re: how to formatting the vba code using Notepad ++,can anyone help me?

Hi, Choose the language that you are using from the toolbar - language menu. There is a specific format for each specific language there. Hence, as you choose VBA, and paste in your code there you ll see the formattying appear. Dont think you can change that Regards, Rohan. -- FORUM RULES (93

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

Have just replicated the same on my own using some sample data. Attach your sheets and I will replicate the same in your sheet as per your needs. Thank you ! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, l

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

Dear Vickey, IPlease share sample worksheet with group. On Thu, Dec 15, 2011 at 9:47 PM, vickey wrote: > Hi, > > I have some issue with data updation realtime, like I have one workbook > having sheet name October / November / December and so on with data. > > Now I want if I select or enter dat

$$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

Hi, I have some issue with data updation realtime, like I have one workbook having sheet name October / November / December and so on with data. Now I want if I select or enter date in sheet1 the i.e 01/12/2011 then return values from December Sheet should return in sheet 1 and if I enter 01

Re: $$Excel-Macros$$ Opening All excel workbook one by one hen running the code

Sub getfilen() '* to get file names in folder Dim fldpath Dim fld, fil As Object Application.FileDialog(msoFileDialogFolderPicker).Title = "Choose Folder" Application.FileDialog(msoFileDialogFolderPicker).Show fldpath = Application.FileDialog(msoFileDialogFolderPicker).Selected

Re: $$Excel-Macros$$ how to restrict character size for a textbox control

Dear Shankar, Please try through below link, hope it will help to u. http://allenbrowne.com/ser-34.html -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

$$Excel-Macros$$ how to formatting the vba code using Notepad ++,can anyone help me?

Hello, I do not know how to formatting the vba code using Notepad ++,can anyone help me step by step? thanks -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem

$$Excel-Macros$$ how to restrict character size for a textbox control

Dear Experts How to restrict character size for a textbox control for MS ACCESS 2003. THANK YOU -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need A

Re: $$Excel-Macros$$ How to create a double click using VBA CODE without actually double clicking on the mouse

Dear Noorin/Rajan verma/Asa rossof, *Thanks for ur response*.I actually created a class module to trap double click event in PIVOT Table,Now the code is written in such a way that when the user againg double clck on drilled down sheet created

Re: $$Excel-Macros$$ I want to do or learn VBA coding and MACRO

Hi Laxman, there is a book by named "Excel 2010 power programming with vba" writer is "John Walkenbach", Publication- "wiley publications". it could be usefull for you. this is a good book for learning excel vba. try it On Fri, Dec 9, 2011 at 3:38 PM, Jorge Marques wrote: > Hi, well i hav