Re: $$Excel-Macros$$ Re: Exrtact only numbers.

2010-07-01 Thread lucky singh
Thank you... Thanx a lot dude... Regards, Jay S On Wed, Jun 30, 2010 at 5:06 PM, devi prasadc devi.pras...@gmail.comwrote: Hi Jay, I could get solutions for couple of things only. Regards DeviPrasad On Wed, Jun 30, 2010 at 4:03 PM, lucky singh lucky60...@gmail.com wrote: 4

$$Excel-Macros$$ Re: Macro to shade every other row

2010-07-01 Thread Stuart Redmann
On 30 Jun. Kurt wrote: 1. The comment in this code has as an example, ShadeAlternateRows Range(A1:D50), 27, 2, but where in the actual code do you put this information? Stuart Redmann wrote: That depends on when the highlighting should happen. Kurt wrote: I'm most interested in

$$Excel-Macros$$ Re: Keywords from QuickBasic to VBA

2010-07-01 Thread Tomaz
I use to program in QBASIC and QuickBasic some 15 years ago. There is a book called The Revolutionary Guide to QBASIC from WROX. There is lot you can use to convert to VB or VBA. On Jun 30, 5:51 am, mikeb mb...@allstate.com wrote: Hi Paul, I was referred by Dave Bonallak, I would appreciate

$$Excel-Macros$$ Re: Keywords from QuickBasic to VBA

2010-07-01 Thread mikeb
Thank you for your help and direction Tomaz! The Best MikeB On Jul 1, 3:51 am, Tomaz tomaz.sil...@gmail.com wrote: I use to program in QBASIC and QuickBasic some 15 years ago. There is a book called The Revolutionary Guide to QBASIC from WROX. There is lot you can use to convert to VB or

$$Excel-Macros$$ Re: Keywords from QuickBasic to VBA

2010-07-01 Thread larry
As one who tries to convert code from old programs to new, here is my experience. If you are switching to Excel with VBA macros the inputs and outputs become different. You can now set up a spread sheet for inputing data. Since the data is visible you don't need to run a sub routine to check your

$$Excel-Macros$$ Re: Macro to shade every other row

2010-07-01 Thread Kurt
You are a hero! Works perfectly. Let this code replace the 400 other, more complicated examples of code I found that attempt to do the same thing. On Jul 1, 2:34 am, Stuart Redmann dertop...@web.de wrote: On 30 Jun. Kurt wrote: 1. The comment in this code has as an example,

Re: $$Excel-Macros$$ Hi, need your help - urgent

2010-07-01 Thread Aindril De
Hi Rajender, I am not quite sure how would you want to do it. However there is a very simple solution mentioned in the link below, which almost does what you are trying to achieve. http://www.excelforum.com/excel-general/713781-display-an-image-based-on-a-cells-value.html

Re: $$Excel-Macros$$ Hi, need your help - urgent

2010-07-01 Thread nifaz islam
hi i need help how i can secure a hidden sheet no any one can unhide and modify it. Regards Ni On Thu, Jul 1, 2010 at 7:38 AM, ashish koul koul.ash...@gmail.com wrote: hi Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If ActiveCell.Row = 2 And

$$Excel-Macros$$ How to increase size and color of text in user form ?

2010-07-01 Thread worawat kh
Dear Group , How to increase size and color of text in user form ? Thanks, Worawat -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ Appending student data from multiple sheets in Chronological order

2010-07-01 Thread KidTeacher
Hi Excel Programmers: Described here is the functionality that staff at a small school would like added to an Excel app for tracking student grades and progress. Any coding help would be greatly appreciated!! Here are the workbook’s parts: There is a sheet named “Students” in which last and

Re: $$Excel-Macros$$ Data Extraction from Database.

2010-07-01 Thread C.G.Kumar
Awaiting for response. On Tue, Jun 29, 2010 at 2:47 PM, Chandra Gupt Kumar kumar.bemlmum...@gmail.com wrote: I am looking to extract data from a large database based on specified criteria. Further, there is need to sort the data based on date criteria. Attached sample data file for your

Re: $$Excel-Macros$$ Trim first 8 characters off a cell

2010-07-01 Thread C.G.Kumar
You can use Mid formulae. By the way you are On Mon, Jun 28, 2010 at 10:25 PM, Nadine S n8dine4ma...@yahoo.com wrote: I have a cell that I'd like to write a formula that returns all but the first 8 characters. The cell's data can be any length. Thanks. Nadine --

RE: $$Excel-Macros$$ Trim first 8 characters off a cell

2010-07-01 Thread Dave Bonallack
=Right(A1,LEN(A1)-8) Regards - Dave. Date: Fri, 2 Jul 2010 09:40:24 +0530 Subject: Re: $$Excel-Macros$$ Trim first 8 characters off a cell From: kumar.bemlmum...@gmail.com To: excel-macros@googlegroups.com You can use Mid formulae. By the way you are On Mon, Jun 28, 2010 at 10:25 PM,

$$Excel-Macros$$ Re: Hi, need your help - urgent

2010-07-01 Thread Soni.Rajender
Hi Thanks for the help, In this I want that if the user can increase or decrease the size of the image, it will change, but next time when the image gets loaded it should have its original dimensions, the image should live within the cell, should not go beyond the cell's dimensions. Regards