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 | 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 25 of 35
Search took 0.01 seconds.
Search: Posts Made By: Tom Urtis
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition October 6th, 2018, 12:20 AM
Replies: 1
Views: 1,233
Posted By Tom Urtis
Thank you for buying my book! The videos are...

Thank you for buying my book!
The videos are located at the link on page xxviii in the section headed "How This Book Is Structured".
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition June 9th, 2016, 10:40 PM
Replies: 4
Views: 1,295
Posted By Tom Urtis
The code for this is certainly doable, but can...

The code for this is certainly doable, but can you please explain why you prefer programming code to accomplish this instead of using conditional formatting?

Conditional formatting can also be...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition April 19th, 2016, 11:57 AM
Replies: 8
Views: 3,863
Posted By Tom Urtis
It will look as if there is no difference in the...

It will look as if there is no difference in the result, because the second If statement is totally unnecessary and irrelevant, and in fact it essentially is not even executed. The first If statement...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition April 18th, 2016, 10:16 AM
Replies: 8
Views: 3,863
Posted By Tom Urtis
You wrote 3 comments in your code, taking each in...

You wrote 3 comments in your code, taking each in turn:

Your comment #1:
"'This code line sets that the code will only work if the column number is from 5 to 10"
Correct, you understand that the...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition April 16th, 2016, 09:48 AM
Replies: 8
Views: 3,863
Posted By Tom Urtis
Delete your entire original Change event code --...

Delete your entire original Change event code -- all the code you first posted and showed on this thread, every line of it, including the line
Private Sub Worksheet_Change(ByVal Target As Range)...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition April 15th, 2016, 03:37 PM
Replies: 8
Views: 3,863
Posted By Tom Urtis
Try replacing the Change event that you posted...

Try replacing the Change event that you posted (which does not work the way you want) with this instead:

Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Column < 3 Or .Column...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition March 27th, 2016, 07:44 PM
Replies: 3
Views: 2,664
Posted By Tom Urtis
Well, a couple things... If you want, you...

Well, a couple things...

If you want, you can bypass VBA by manually setting up data validation for cell D1 with a drop-down list of those 5 allowable items 10250, 10450, 10700, 10710 or 10720. If...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition March 26th, 2016, 12:44 PM
Replies: 3
Views: 2,664
Posted By Tom Urtis
Thank you for buying the book. Just to get...

Thank you for buying the book.

Just to get things started, I revised your code with a few changes:
• The Alert style is Stop (instead of Information as you had it), because you intend to only...
Forum: BOOK: Excel VBA 24-Hour Trainer March 22nd, 2016, 06:33 PM
Replies: 1
Views: 1,444
Posted By Tom Urtis
Those files were created for the Second Edition...

Those files were created for the Second Edition of the book, which you can download from the link on this web page here:
...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition March 12th, 2016, 07:59 PM
Replies: 1
Views: 929
Posted By Tom Urtis
That 424 error is usually due to an invalid...

That 424 error is usually due to an invalid object qualifier, or an unrecognizable object, or a missing Set statement. On an unrelated caveat, the LastRow variable is of the Integer type, but if your...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition February 20th, 2016, 01:57 AM
Replies: 6
Views: 1,417
Posted By Tom Urtis
Colin - - My email address is on the "About the...

Colin - -
My email address is on the "About the Author" page near the front of the book. Send me your email address and I will send you a workbook example based on the scenario you described.
Forum: Excel VBA January 6th, 2016, 05:58 PM
Replies: 2
Views: 588
Posted By Tom Urtis
Which 12 of the columns do you want to keep?

Which 12 of the columns do you want to keep?
Forum: BOOK: Excel VBA 24-Hour Trainer January 6th, 2016, 12:35 AM
Replies: 1
Views: 1,233
Posted By Tom Urtis
Hi, and thanks for buying the book. That...

Hi, and thanks for buying the book.

That error can be due to a couple of reasons. For example, if the strTo variable contains an illogical recipient name (such as, in a cell, a name has a space or...
Forum: BOOK: Excel VBA 24-Hour Trainer January 5th, 2016, 11:36 PM
Replies: 8
Views: 3,633
Posted By Tom Urtis
The code to do what you said you want, which is...

The code to do what you said you want, which is to activate the worksheet whose name is in the ActiveX ComboBox named ComboBox1, is as follows.

To install it in your workbook, first, copy this...
Forum: BOOK: Excel VBA 24-Hour Trainer January 4th, 2016, 11:18 PM
Replies: 8
Views: 3,633
Posted By Tom Urtis
What is the name of the combobox? You can select...

What is the name of the combobox? You can select the combobox on the sheet in Design mode and seeing its name in the Name Box.

And just to be clear, you want to select a worksheet whose tab name...
Forum: BOOK: Excel VBA 24-Hour Trainer January 4th, 2016, 02:34 PM
Replies: 8
Views: 3,633
Posted By Tom Urtis
Can you explain more about your project, what you...

Can you explain more about your project, what you are working with, and what your expected results are. Especially, please explain exactly where the combobox is -- you characterized it as a userform...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition January 1st, 2016, 07:56 PM
Replies: 6
Views: 2,055
Posted By Tom Urtis
As you will see later in the book, where VBA is...

As you will see later in the book, where VBA is concerned, the parent object (in this case, the worksheet where the sort should take place) must be defined. VBA needs to know which worksheet you want...
Forum: BOOK: Excel VBA 24-Hour Trainer January 1st, 2016, 03:27 PM
Replies: 1
Views: 2,358
Posted By Tom Urtis
Hi, and thank you for buying the book. ...

Hi, and thank you for buying the book.

Downloadable code was not available for examples on the book's pages in the first edition in 2011. But in 2015, I wrote the second edition and there is a...
Forum: BOOK: Excel VBA 24-Hour Trainer January 1st, 2016, 03:18 PM
Replies: 8
Views: 3,633
Posted By Tom Urtis
Hello Alberto, thank you for buying the book. ...

Hello Alberto, thank you for buying the book.

See if the example and downloadable workbook from my blog helps you to see how to have a combobox on your Ribbon as an add-in from which you can...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition January 1st, 2016, 01:55 PM
Replies: 6
Views: 2,055
Posted By Tom Urtis
Hi, and thanks for buying the book. ...

Hi, and thanks for buying the book.

Something is affecting the results you are getting (or not getting) that, based on your description, I cannot replicate.

Just now, I created this example...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition January 1st, 2016, 01:19 PM
Replies: 6
Views: 1,417
Posted By Tom Urtis
Hello Colin, thanks for buying the book. The...

Hello Colin, thanks for buying the book.

The short answer to your question from a programming standpoint is yes, it is possible for a user to enter data in a multi-column UI on a UserForm. The...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition December 25th, 2015, 09:58 AM
Replies: 3
Views: 714
Posted By Tom Urtis
Just thinking of a couple ideas, because the...

Just thinking of a couple ideas, because the challenge is not seeing your Import worksheet layout of the actual data.

Have you tried to use the Subtotal method in VBA to programmatically sort the...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition December 21st, 2015, 08:52 PM
Replies: 3
Views: 714
Posted By Tom Urtis
Hello Ty - - Thanks for buying my book and...

Hello Ty - -

Thanks for buying my book and for your kind words about how it helped your project.

I read your message a few times and have a couple questions to make sure I understand the entire...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition November 4th, 2015, 02:30 PM
Replies: 4
Views: 5,184
Posted By Tom Urtis
Thank you for buying the book. I am not...

Thank you for buying the book.

I am not clear in understanding your question. It sounds like you want to show a menu when clicking or mousing over (per your reference to "move a cursor on") a...
Forum: BOOK: Excel VBA 24-Hour Trainer 2nd edition October 13th, 2015, 04:23 PM
Replies: 12
Views: 2,356
Posted By Tom Urtis
Not being a Mac user myself, I'll put the word...

Not being a Mac user myself, I'll put the word out to Excel experts I know who do use Macs. I know that VBA with Macs is not as seamless a combination as with PCs, and it might be, depending on the...
Showing results 1 to 25 of 35

 


All times are GMT -4. The time now is 10:44 PM.


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