$$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
Rajender Soni

On Jul 1, 5:14 pm, Rajender Soni  wrote:
> Hi
>
> Pls find attached the excel file, I just want that when I move my mouse
> cursor over a cell, the image having the name equal to cell's value will get
> displayed, pls open the attached excel file for more clarification.
>
> Regards
> Rajender Soni
>
>  image.xlsx
> 168KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

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, Nadine S  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





-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe



-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
  
_
Need a new place to live? Find it on Domain.com.au
http://clk.atdmt.com/NMN/go/157631292/direct/01/

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

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  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
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

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 consideration.
>
>
>
> Please use other than data filter criteria and also let me know whether it
> is possible to accomplished with Macro or not ?
>
>
>
> Regards,
>
>
>
> C.G.Kumar
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$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 first names of
students are imported into cols A and B. On this sheet are also two
Microsoft Date Time Picker controls for selecting starting and ending
report dates.

There are 7 worksheets named Period 1, Period 2,…, Period 7 (for 7
different school classes). A student may be entered in just one of the
periods, may be in 3 periods, all 7 periods, whatever. If they're in
multiple periods, students are Not necessarily entered on the same
rows.

A worksheet named “Progress Report Template” is in the workbook to be
used for reports.

Here is the basic setup of the 7 worksheets named Period 1, Period 2,
…, Period 7:

Last and first names of students are in columns B and C on every ODD
row, starting on row 13.

Dates are inserted in row 12; each day’s date is in a separate column.
There are other headings along this row, not just dates, but the date
columns are entered consecutively.

Comments about a student’s work that period are typed in the date
columns, but 1 row Below which the student’s names have been inserted
(so the comments are on every EVEN row).

Here is the desired functionality:

Teachers would like to go to the sheet named “Students,” select
starting and ending dates from the Microsoft Date Time Picker controls
(E3 and E5), click a blank cell next to a student’s name (to select
that student to report on), say, a cell in col D, and then have Excel
do the following:

1. Store the last and first names of the student from cols A and B as
variables.

2. Store the starting and ending dates from E3 and E5.

3. Create a copy of the worksheet named “Progress Report Template” in
the workbook.

4. Rename the copy of “Progress Report Template” with the student’s
first and last names.

5. In the student’s new report worksheet, input his/her last name in
cell B1 and his/her first name in B2.

6. In the student’s new report worksheet, insert the starting date in
B6 (or a row below any existing data).

7. Here’s the crazy part – scan Period 1 for the student’s last and
first names (would be in cols B and C on the "Period" sheets).  If
found, do the following:

8. Copy the typed comment (if any) in the cell at the intersection of
1 row below the student’s names (cols B and C) and the column with the
date heading in row 12 that matches the starting date.

9. Return to the student’s report worksheet and insert the starting
date in cell B6 and the corresponding comment in cell C6 (or a row
below existing data).

10. Then, go to and scan Period 2 and do the same if the student is
present—copy the comment at the intersection of 1 row below the
student’s names and the column with the matching date in row 12,
return to the student’s report worksheet and insert the date and
comment [a row below the previously used row].

11. Repeat this for each Period’s sheet.

12. AND—for a range of dates (from the Microsoft Date and Time Pickers
in the Student’s sheet)—repeat this for the next consecutive date—
scanning the Period worksheets, copying the comments for the students
on those days, then copying and listing them on the student’s report
sheet.

13. Lastly, set the newly inserted dates and corresponding comments as
the new print range (everything above row 5 will be the page’s
heading).

Don’t want very much do we?  Does this make sense? I realize this is
very complex. Again, any help on this would be super appreciated.
Thanks.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$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 : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

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  wrote:

> hi
>
>
> Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
> Boolean)
>
>
> If ActiveCell.Row = 2 And ActiveCell.Column = 1 Then
>
> Call deletshape
>
>
>
>  Sheets("Sheet1").Select
> Range("E9").Select
> Selection.Delete
>
>  Sheets(2).Shapes(1).Copy
> Sheets("Sheet1").Select
> Range("E9").Select
> ActiveSheet.Paste
>
>
> ElseIf ActiveCell.Row = 3 And ActiveCell.Column = 1 Then
> Call deletshape
>  Sheets(2).Shapes(2).Copy
> Sheets("Sheet1").Select
> Range("E9").Select
> ActiveSheet.Paste
>
>
> ElseIf ActiveCell.Row = 4 And ActiveCell.Column = 1 Then
> Call deletshape
>
>  Sheets(2).Shapes(3).Copy
> Sheets("Sheet1").Select
> Range("E9").Select
> ActiveSheet.Paste
>
>
> ElseIf ActiveCell.Row = 5 And ActiveCell.Column = 1 Then
> Call deletshape
>
>  Sheets(2).Shapes(4).Copy
> Sheets("Sheet1").Select
> Range("E9").Select
> ActiveSheet.Paste
>
> End If
>
> End Sub
>
> Sub deletshape()
> Dim sh As Shape
>
>
>For Each sh In Sheets(1).Shapes
>
>  If sh.Type = msoPicture Then
>   sh.Delete
>End If
> Next sh
>
> End Sub
>
>
> ashish koul
>
> akoul.blogspot.com
>
>
>
> On Thu, Jul 1, 2010 at 5:44 PM, Rajender Soni wrote:
>
>> Hi
>>
>> Pls find attached the excel file, I just want that when I move my mouse
>> cursor over a cell, the image having the name equal to cell's value will get
>> displayed, pls open the attached excel file for more clarification.
>>
>> Regards
>> Rajender Soni
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Kindly Regards
Nifaz Islam

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

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


Regards,
Andy

On Thu, Jul 1, 2010 at 5:44 PM, Rajender Soni wrote:

> Hi
>
> Pls find attached the excel file, I just want that when I move my mouse
> cursor over a cell, the image having the name equal to cell's value will get
> displayed, pls open the attached excel file for more clarification.
>
> Regards
> Rajender Soni
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$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  wrote:
> 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 learning how to do it manually (e.g., after
> > manually selecting a range).
>
> Ok. First of all, you can only use subs that take no arguments (and
> then it does not matter where you put it). The macro must be re-
> designed to use the current selection (also we have to fix the step
> width and the color):
>
> Public Sub ShadeAlternateRows()
>   With Selection
>         ' remove any previous shading
>         .Interior.ColorIndex = xlColorIndexNone
>
>         ' Shade every second row in yellow (= color index 27)
>         Dim r As Long
>         For r = 2 To .Rows.Count Step 2
>            .Rows(r).Interior.ColorIndex = 27
>         Next r
>     End With
> End Sub
>
> Now you this sub appears in the macro list and can be assigned a
> shortcut. If you need to be able to use different colors, you'll have
> to pop up a dialog that lets the user choose a color.
>
> Regards,
> Stuart

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$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 inputs unless there are specifc constaints that
don't work.I use cells().value a lot.

On Jun 30, 7:51 am, mikeb  wrote:
> Hi Paul,
>
> I was referred by Dave Bonallak, I would appreciate any help you can
> give.
>
> I have a very old program written in QuickBasic 4.5 which does a lot
> of statistics and printing the results in colorful graphic charts.  I
> could use a lot of what this program does, however being a DOS program
> isn’t very friendly, so I thought maybe I could convert parts, it is
> very modular, to VBA and was wondering if you know a source where I
> can find a list of QuickBasic Keywords that have been correlated to
> their counterpart in VBA.  If you have time and can respond I would
> appreciate your help.
>
> Thank you,
>
> MikeB

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$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  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 VBA.
>
> On Jun 30, 5:51 am, mikeb  wrote:
>
>
>
> > Hi Paul,
>
> > I was referred by Dave Bonallak, I would appreciate any help you can
> > give.
>
> > I have a very old program written in QuickBasic 4.5 which does a lot
> > of statistics and printing the results in colorful graphic charts.  I
> > could use a lot of what this program does, however being a DOS program
> > isn’t very friendly, so I thought maybe I could convert parts, it is
> > very modular, to VBA and was wondering if you know a source where I
> > can find a list of QuickBasic Keywords that have been correlated to
> > their counterpart in VBA.  If you have time and can respond I would
> > appreciate your help.
>
> > Thank you,
>
> > MikeB- Hide quoted text -
>
> - Show quoted text -

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$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  wrote:
> Hi Paul,
>
> I was referred by Dave Bonallak, I would appreciate any help you can
> give.
>
> I have a very old program written in QuickBasic 4.5 which does a lot
> of statistics and printing the results in colorful graphic charts.  I
> could use a lot of what this program does, however being a DOS program
> isn’t very friendly, so I thought maybe I could convert parts, it is
> very modular, to VBA and was wondering if you know a source where I
> can find a list of QuickBasic Keywords that have been correlated to
> their counterpart in VBA.  If you have time and can respond I would
> appreciate your help.
>
> Thank you,
>
> MikeB

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$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 learning how to do it manually (e.g., after
> manually selecting a range).

Ok. First of all, you can only use subs that take no arguments (and
then it does not matter where you put it). The macro must be re-
designed to use the current selection (also we have to fix the step
width and the color):

Public Sub ShadeAlternateRows()
  With Selection
' remove any previous shading
.Interior.ColorIndex = xlColorIndexNone

' Shade every second row in yellow (= color index 27)
Dim r As Long
For r = 2 To .Rows.Count Step 2
   .Rows(r).Interior.ColorIndex = 27
Next r
End With
End Sub

Now you this sub appears in the macro list and can be assigned a
shortcut. If you need to be able to use different colors, you'll have
to pop up a dialog that lets the user choose a color.

Regards,
Stuart

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe