Home Register Calendar Today's Posts FAQ Free Publications
Page 1 of 20 1 2345611 Last »
Showing results 1 to 25 of 500
Search took 0.11 seconds. Search: Posts Made By: Cas
Forum: Excel 07-10-2008, 04:44 AM
Replies: 5
Views: 381
Posted By Cas
You can also change the default show state by...

You can also change the default show state by setting the ShowModal property in the properties dialog (not available programmatically).
Forum: General 07-10-2008, 04:34 AM
Replies: 1
Views: 2,716
Posted By Cas
If your dates are all this year's, you just need...

If your dates are all this year's, you just need to strip away the beginning and end, CDate("Jul 9 11:00:00") works directly. If the year might differ, you have to parse the string and put it in a...
Forum: Interface and Graphics 07-09-2008, 05:15 PM
Replies: 1
Views: 983
Posted By Cas
Possible cause: The Change event will fire each...

Possible cause: The Change event will fire each time the TextBox contents change. So, if the Text is, say "20" and you press backspace twice and then "3" and "0" to enter "30", the change event will...
Forum: Excel 07-09-2008, 03:32 PM
Replies: 7
Views: 318
Posted By Cas
The IDE actually gives you more information than...

The IDE actually gives you more information than that. If you look closely, it highlights the name that's giving rise to the error the message describes. In this case, what it highlights is...
Forum: General 07-09-2008, 01:45 PM
Replies: 2
Views: 223
Posted By Cas
Hi Jason, you'll probably get better replies...

Hi Jason,

you'll probably get better replies if you explain what "fkceditor" is. Good rule of thumb: if both MSDN and wikipedia searches for a term return empty, you should probably define it or...
Forum: Excel 07-09-2008, 01:35 PM
Replies: 34
Views: 817
Posted By Cas
Well, the most naive (but not necessarily worst)...

Well, the most naive (but not necessarily worst) approach would be to simply check if a given row has already been coloured. So, based on shg's code, you could just wrap the inner loops in if-blocks:...
Forum: Excel 07-09-2008, 01:23 PM
Replies: 10
Views: 982
Posted By Cas
Okay, I think I understand better now. The basic...

Okay, I think I understand better now. The basic approach to use is the same as the one I suggested previously, but instead of looping over all ten rows, we want to first find the number of the row...
Forum: Excel 07-09-2008, 12:49 PM
Replies: 34
Views: 817
Posted By Cas
Okay, so, after all the confusion, I guess we're...

Okay, so, after all the confusion, I guess we're back at what you were asking about in post #17:

Do you need further assistance with that part?
Forum: Excel 07-09-2008, 12:33 PM
Replies: 34
Views: 817
Posted By Cas
So, just to make sure we're understanding you...

So, just to make sure we're understanding you correctly this time, my third example in post #22 should be coloured like so, yes?

1 2 3 4 5
3 4 5 6 7
5 6 7 8 9


I'm not entirely sure why they...
Forum: Tech Discussions 07-09-2008, 09:04 AM
Replies: 11
Views: 2,476
Posted By Cas
It would be great to extend this approach to...

It would be great to extend this approach to Sheets, but it'll be a lot more difficult than what I've accomplished so far, because as explained above this would require duplication of all message...
Forum: Excel 07-09-2008, 08:55 AM
Replies: 10
Views: 982
Posted By Cas
What, specifically, defines one row as current or...

What, specifically, defines one row as current or active?
Forum: Random Thoughts 07-09-2008, 07:29 AM
Replies: 28
Views: 949
Posted By Cas
"Master" is a more appropriate title than...

"Master" is a more appropriate title than "Doctor" for a Sith, anyway. ;)
Forum: Excel 07-09-2008, 06:30 AM
Replies: 13
Views: 640
Posted By Cas
Ah, I see. Thanks for elaborating. The best...

Ah, I see. Thanks for elaborating.

The best way to narrow this down would be with the usual debug techniques. Check the contents of the numeric array after the separation and before the sort, that...
Forum: Random Thoughts 07-09-2008, 05:56 AM
Replies: 28
Views: 949
Posted By Cas
Dr darkforcesjedi, I presume? ;)

Dr darkforcesjedi, I presume? ;)
Forum: Forum Questions / Concerns / Comments 07-09-2008, 05:38 AM
Replies: 18
Views: 1,208
Posted By Cas
Hi Rapiant, this forum and yours are using a...

Hi Rapiant,

this forum and yours are using a different forum software. So I'm not sure your conclusions are entirely valid. ;)
Forum: Excel 07-08-2008, 06:21 PM
Replies: 10
Views: 982
Posted By Cas
Hi Victoria, welcome to the forum! :) You...

Hi Victoria, welcome to the forum! :)

You can reference controls by name via the form's Controls collection. For example, this would put the text "abc" into the textboxes named "TextBox1",...
Forum: Excel 07-08-2008, 05:34 PM
Replies: 34
Views: 817
Posted By Cas
... for Even Column Counts", to be precise, if it...

... for Even Column Counts", to be precise, if it is to fulfill "shg's Strictly Empty Intersection Criterion". ;)
Forum: Excel 07-08-2008, 04:01 PM
Replies: 34
Views: 817
Posted By Cas
I'm still not entirely clear on the scheme you...

I'm still not entirely clear on the scheme you want to use. I mean, these two are obvious, unless I misunderstood something:

1 2 3 4 5
1 2 3 1 2
4 5 3 4 5


1 2 3 4 5
5 6 7 8 9
1 2 3 1 2
Forum: Excel 07-08-2008, 03:49 PM
Replies: 7
Views: 1,932
Posted By Cas
Yes, so it would. I was just happy that there was...

Yes, so it would. I was just happy that there was a usable event in the first place! :)

Thanks! :cool:

I thought shg did a really good job of explaining the approach in post #3.

We need a...
Forum: Excel 07-08-2008, 02:59 PM
Replies: 10
Views: 2,176
Posted By Cas
It's unlikely that anyone here will have that...

It's unlikely that anyone here will have that sort of experience, I'm afraid. As it doesn't really have anything to do with Excel or even VBA, you'd probably get better feedback in a forum that...
Forum: Random Thoughts 07-08-2008, 11:37 AM
Replies: 28
Views: 949
Posted By Cas
Knock 'em dead, darkforcesjedi! *goes off to...

Knock 'em dead, darkforcesjedi!

*goes off to try and chop veggies for dinner with crossed fingers, hoping not to be chopping crossed fingers*
Forum: Excel 07-08-2008, 11:33 AM
Replies: 7
Views: 1,932
Posted By Cas
Fortunately, they seem to have thought of this...

Fortunately, they seem to have thought of this case. :)

The Change event fires when you insert a row, and passes the new row in the Target parameter.
Forum: Excel 07-08-2008, 10:51 AM
Replies: 17
Views: 1,019
Posted By Cas
Are you sure? To make it clearer: For Each...

Are you sure? To make it clearer:
For Each thisShape In Worksheets("Sheet1").Shapes

will loop over the Shapes collection of Sheet1.
For Each thisShape In Worksheets("Sheet2").Shapes

will loop...
Forum: Excel 07-08-2008, 05:47 AM
Replies: 7
Views: 656
Posted By Cas
Hi macer, only got around to looking at it...

Hi macer,

only got around to looking at it today, sorry.

On a general level, I'd recommend to use Option Explicit and scoping keywords. Have a look at the "snp" (post #6) and "Anatomy of a...
Forum: Excel 07-08-2008, 05:30 AM
Replies: 13
Views: 640
Posted By Cas
I'm not quite sure what you're asking, is the...

I'm not quite sure what you're asking, is the code working as it should? It's certainly the right approach, using Len and Left/Mid/Right. InStr would also be useful.
Showing results 1 to 25 of 500
Page 1 of 20 1 2345611 Last »

 
Forum Jump
Advertisement:



Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe

Home
Register
Calendar
Today's Posts
FAQ
Archive
© Xtremevbtalk.com 2001 - 2013. All Rights Reserved.    


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.