Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 16 of 16
Search took 0.01 seconds.
Search: Posts Made By: tomurtis
Forum: Excel VBA May 1st, 2018, 12:09 PM
Replies: 9
Views: 910
Posted By tomurtis
This will do that: Sub ColorFontManyCells() ...

This will do that:

Sub ColorFontManyCells()
Application.ScreenUpdating = False
Dim cell As Range, xRow As Long, LastRow As Long
LastRow = Cells(Rows.Count, 4).End(xlUp).Row
Range("D3:D" &...
Forum: Excel VBA May 1st, 2018, 12:00 PM
Replies: 9
Views: 910
Posted By tomurtis
Which column is it, and in what cell does the...

Which column is it, and in what cell does the list begin. I realize the list can be any length, I don't need to know the last cell of the list, just the column and what cell you prefer to start in.
Forum: Excel VBA May 1st, 2018, 11:32 AM
Replies: 9
Views: 910
Posted By tomurtis
You're quite welcome. Post back if you have many...

You're quite welcome. Post back if you have many cells in a range with varying string lengths and you need a loop for this instead of just for one cell.
Forum: Excel VBA April 30th, 2018, 03:16 PM
Replies: 9
Views: 910
Posted By tomurtis
Is this data static as a constant value, meaning...

Is this data static as a constant value, meaning it is NOT produced by a formula?

If the data is produced by a formula, you cannot accomplish the task you speak of.

If the data is not produced...
Forum: Excel VBA April 30th, 2018, 02:56 PM
Replies: 2
Views: 1,505
Posted By tomurtis
Well, let's see. If it were me, and there were...

Well, let's see.
If it were me, and there were a dozen or more controls to behave the same way, I'd use a class module. Seeing as there are only 4, one on each sheet, I'd write a macro to do what...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition May 14th, 2017, 08:59 PM
Replies: 1
Views: 1,308
Posted By tomurtis
I don't understand your question. Page 10 of the...

I don't understand your question. Page 10 of the book is blank, after the last page of Lesson 1 and before the first page of Lesson 2. Also, it's not clear what you mean by default view, in terms of...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition January 10th, 2017, 05:38 PM
Replies: 8
Views: 2,348
Posted By tomurtis
Hi Steve - - Thank you for purchasing the book....

Hi Steve - -
Thank you for purchasing the book. The link you asked about is on page xxviii (the Introduction section), under "How This Book is Structured".
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition January 10th, 2017, 05:34 PM
Replies: 7
Views: 2,302
Posted By tomurtis
Hi Steve - - Thanks for buying the book. The...

Hi Steve - -

Thanks for buying the book. The link to the videos is on page xxviii, in the second-to-last sentence of the paragraph entitled "How This Book is Structured".
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition October 5th, 2016, 08:13 PM
Replies: 9
Views: 1,563
Posted By tomurtis
For future reference, you can list the 255 ascii...

For future reference, you can list the 255 ascii characters on a sheet by entering this function in a cell in row 1, such as cell A1, and copying it down to cell A255:

=CHAR(ROW())
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition September 30th, 2016, 02:10 PM
Replies: 9
Views: 1,563
Posted By tomurtis
I tested the code before I posted it so I am sure...

I tested the code before I posted it so I am sure it works.

I don't understand why you are using both a Change event and a KeyPress event. If the Change event is only for the manual entry of the...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition September 29th, 2016, 05:38 PM
Replies: 9
Views: 1,563
Posted By tomurtis
Your KeyPress event can be changed to this to...

Your KeyPress event can be changed to this to achieve the effect you are after.


Private Sub txbCorDep_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)

Select Case KeyAscii

'Plus sign, one...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition September 27th, 2016, 07:45 PM
Replies: 9
Views: 1,563
Posted By tomurtis
Well, a couple things... First, you wrote...

Well, a couple things...

First, you wrote "e.g. 3.12e06" when really it is expressed in Excel's scientific format as 3.12E+06.

In any case, the letter e (or E) is not regarded as a text letter...
Forum: BOOK: Excel VBA 24-Hour Trainer July 16th, 2016, 10:56 AM
Replies: 1
Views: 3,313
Posted By tomurtis
Can you please clarify what "dropdown list"...

Can you please clarify what "dropdown list" means. Is it data validation that's been applied to cell C7? Or is it a combobox from the ActiveX Toolbox that's embedded onto cell C7.

Also, how do the...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition June 12th, 2016, 11:31 AM
Replies: 4
Views: 1,151
Posted By tomurtis
Just to get things started, assuming... •...

Just to get things started, assuming...
• your range of numbers begins in column A, in row 2
• it doesn't matter how many rows and columns your range spans
...then this worked for me, using...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition June 7th, 2016, 03:19 PM
Replies: 8
Views: 2,348
Posted By tomurtis
Hi Kaley, thank you for buying the book. In...

Hi Kaley, thank you for buying the book.

In the book's Introduction section on page xxviii (in the "How this book is structured" paragraph) is this link to watch all the videos:
[secret customer...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition June 7th, 2016, 02:59 PM
Replies: 1
Views: 965
Posted By tomurtis
Hello and thank you for buying the book. ...

Hello and thank you for buying the book.

Good question. As far as I know, unfortunately the videos are not available for individual download, only viewable on line.
Showing results 1 to 16 of 16

 


All times are GMT -4. The time now is 01:48 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.