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 12 of 12
Search took 0.01 seconds.
Search: Posts Made By: Martin Outlaw
Forum: Excel VBA November 13th, 2007, 01:25 PM
Replies: 12
Views: 2,461
Posted By Martin Outlaw
Why don't you just use .To =...

Why don't you just use

.To = Application.worksheetfunction .......
Forum: Excel VBA August 23rd, 2006, 05:13 AM
Replies: 2
Views: 1,177
Posted By Martin Outlaw
Many thanks, It works well. I had tried...

Many thanks, It works well.

I had tried using the 'on error resume next', and 'on error Goto', without any success. I was putting it after the IsError line so it wasn't working.
Forum: Excel VBA August 22nd, 2006, 10:38 AM
Replies: 2
Views: 1,177
Posted By Martin Outlaw
Run time errors

What I am trying to do is search a currentregion for all dates stored as text and convert them to proper dates using the datevalue function. However when the code picks up a cell value that is...
Forum: Excel VBA October 27th, 2005, 10:12 AM
Replies: 1
Views: 717
Posted By Martin Outlaw
in cell C8 (for example)format as percentage ...

in cell C8 (for example)format as percentage
=IF(C7=0.0975, "No Variance", C7-0.0975)
Forum: Excel VBA December 3rd, 2004, 11:00 AM
Replies: 1
Views: 1,254
Posted By Martin Outlaw
Your suggection for comboboxes is fine, they...

Your suggection for comboboxes is fine, they could easily pick up data from a 2 column RowSource, make sure your combobox has 2 columns and the bound column is 2, this way you get the data and not...
Forum: Excel VBA October 5th, 2004, 04:43 AM
Replies: 3
Views: 2,190
Posted By Martin Outlaw
I had a similar problem with a large workbook,...

I had a similar problem with a large workbook, one sheet contain 80,000 formulas. It took forever to load, save, recalculate, and it frequently crashed.

I replaced the 80,000 formulas with about...
Forum: Excel VBA October 5th, 2004, 04:31 AM
Replies: 14
Views: 80,423
Posted By Martin Outlaw
When you come across a problem such as this a...

When you come across a problem such as this a good way around it is to record a macro.

Go to a separare workbook and record a macro, select the cell and format the cell with fill colour, borders...
Forum: Excel VBA July 26th, 2004, 11:25 AM
Replies: 2
Views: 3,810
Posted By Martin Outlaw
you should try something like this. Private...

you should try something like this.

Private Sub FilterData()

Worksheets("Data").Range("A1").AutoFilter Field:=6, Criteria1:="Open"
Worksheets("Data").Range("A1").CurrentRegion.Copy...
Forum: Excel VBA June 7th, 2004, 03:20 AM
Replies: 4
Views: 2,803
Posted By Martin Outlaw
Many thanks

Many thanks
Forum: Excel VBA June 4th, 2004, 11:05 AM
Replies: 4
Views: 2,803
Posted By Martin Outlaw
Thanks, This does work, but I wish to use...

Thanks,

This does work, but I wish to use these combobox dates to filter a report which contains date formats, converting the combobox to text would require converting the report dates to text...
Forum: Excel VBA June 3rd, 2004, 06:33 AM
Replies: 3
Views: 935
Posted By Martin Outlaw
It is as acdsky said, from the "Control...

It is as acdsky said,

from the "Control Toolbox" toobar select Command button.

The cursor changes to a small cross, move to area of sheet you wish the buttoon to be, click and hold left mouse...
Forum: Excel VBA June 3rd, 2004, 06:20 AM
Replies: 4
Views: 2,803
Posted By Martin Outlaw
Combobox format

I am having difficulty with a combobox, It is reading data from a list of dates, but when an item is selected it displays in the text format. (01/12/2003 -> 37956). How do I stop this from...
Showing results 1 to 12 of 12

 


All times are GMT -4. The time now is 08:25 PM.


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