Search:

Just a question and certainly not a correction, but shouldn't we be using the vba.date(vba.year(vba.today....etc? to make this global?

Just a question?

Thanks,
Darryl.

I didn't notice any mispells, the problem stems from the variable string, which I think was a mistake on my part. The special notation ' for some reason needs a valid date variable imo. Once I...

Yes I did, and I got the error , 1004 This operation is not available for extrenal Database.

And Thank you for you effort.

oops...I meant the captial S, see how it didn't change itself to a capital, if you declare the variable as a capital S, doesn't see the s, and it keeps it small, I think the ' symbol is key to my...

rory, thanks for your reply

if you take a look at the variable, you will notice that in declaration there is a B S....but in the code it doesn't see it.

Option Explicit
Sub Macro1()
Dim sYear As String
Dim sMonth As String
Dim sDay As String
sYear = "2011"
sDay = "13"
sMonth = "06"
Range("A1").Select
With...

Hi Guys,

Been some time since I was last here, hope all is well with the forum.
I have a database query macro that I recorded, and want to modify the dates but everytime I put a variable to the...

Thanks for the help, I would like to know, since I am dealing also with decimals, like 8.25, what variable should I use? I keep losing the .25 when it converts the number over, should I avoid single...

Hey Guys,

I need help with this, what I am trying to do is extract a value from a string, in the string there is (35), or could be a any number within brackets, which I need for a calculation, can...

Thanks dude,

I tried a few variations of the code, I have never passed an object with an argument.

Thank you kindly.

HUH:)


Oops that not true...I have, but I haven't used it as the...

Is this a legal function?

Any one?



Public Function TestAreAnyTrue(ZX As Collection) As Boolean
Dim ctl As Control
TestAreAnyTrue = False
For Each ctl In ZX

Hey Rory,

Thanks for your reply,

You gave me that code about 4 years ago:)

Can you tell me why I can't get this to work?

Passing ZX would be an arugment like Userform1.frame1.controls?

Hi all,

I am trying to populate an array fill with values, I have a parsed text string that I would like to store with 13 seperate values. I would like the array to be dynamic, the reason for this...

Hi all,

I am trying to test buttons again, I have a form with more than a few optionbuttons inside a frame control, in the frame, I also have other controls, but none that would give a true false...

Thanks Hans.

Hello everyone,

I have an issue with I think not screen resolution, but screen size, I think.

I created a form in Excel, on a standard screen, with Max resolution, 1280X1024, on one computer,...

Thanks Hans,

I'll take your advice on removing the -1, from the (plate), because I am using the split function on the Arrparts, it has produces " " elements in the Array, so I'll keep the -1 when...

Hi all,

I am trying count down an Array, I can't figure out how get all the items in the array to fill a listbox, my problem is I keep missing the last item in the array, this is just a snippet of...

Thanks Hans,
http://windowssecrets.com/forums/images/smilies/evilgrin.gif

Hi all,

I wanted to ask, can someone see the error with this code, I keep getting an application error, object not set.....


Thanks,
Darryl.

Do you already have a list of names? on a worksheet?

Are you trying to accomplish in code?

Thanks,
Darryl.

You guys really are experts!

I changed the format of the cell to General, and input the value and it is ok now,

Thanks,
Darryl.

Hi all,

I have a cell that within the cell the value repeats itself. I have tried many things to correct, checked the conditional formatting, there is none, checked everthing that I can think of,...

http://windowssecrets.com/forums/images/smilies/rolleyes.gif

Hans,

Thanks, I figured it out, what a blast! I had the sheet in page break Preview, is the commandbar object only available in normal view?

Thanks,
Darryl.