Search:

hi,

I dont know if this is an Excel or a Windows issue -- but i believe it's a Windows issue.

In Excel...
1. I created a vba/macro code that does a particular thing.
2. It is attached to a...

I am not quite sure of your intentions. But the most glaring error I can see are

1 - you assign an entire array of 'a' to a single range (which may be a single cell or a group of cells). You must...

Insert this statement before assigning text boxes values to your recordset


ado1DailyIncome.AddNew

Call ClassModule1.initializationMethod (Argument1, ArrayOfUDTS(i) as Argument 2) <---------?

If this is a class module, then create an object first and set this class to it, Example:


Dim xxx...

Unless the source data has exactly the same structure as the destination data structure, you cannot just use Copymemory. You must assign that data part individually like assigning a particular...

Can you elaborate more on this? ....

Quote:
"... but what the exact time of sendkeys one of these buttons to simulate a left mouse click and result shift + click or ctrl + click, I can not find...

You might ask yourself: "If I know how to write VBA codes, do I still need to learn Macro?"

Well, actually you can do away with Macro but it could be a poor choice to do so. While I consider...

put it inside a glass cabinet and put the cabinet facing your visitor's chair

Check first if the list box you have inserted is an activeX or from excel form menu. The later can only fetch data by setting one of its property to a range of cells.

Another thing to check is the...

If you want to use the click event as interrupter - you can't do away with DoEvents. You may also try the Timer events if it will work on your needs.

Seems similar to Newtonian physics -- that can be used for interplanetary computations but not accurate enough for intergalactic computations?



Ok, so it's like when I was in college I studied...

One of my kids took Applied Physics (AP) in college. Ok, so she wants to be an “Einstein” – that’s what I thought. She often makes her college notes available to us (parents). As expected, I saw...

Opps, I was late. I was actually previewing the post (reply) when i noticed it has been resolved. Anyway I suggested a commandbutton ...


Private Sub Command0_Click()
RunWordMacroOrSub
End...

On the other hand, it may get pretty well. Imagine yourself having a gf and she tells her forum mates "you have her" --unless "you have others" too. :D

Simplify your choice:

Do you want spending time tinkering on the machine’s intricacies? Go for courses related to networking.

Do you want spending time solving real world problems? Go for...

Very expensive? Wrong -- it's very very expensive.

Very difficult to fly? -- F-22 is just the hardware portion. The fly-by-wire system is the software part. The hardware is really made to be...

From what I understand you cannot delete the codes while it is still running unless you are referring to deleting codes in another file.

It's like any application that cannot erase itself -- nor...

The term "medical software" is so broad. But by the way you described it, you may take a look at MS Access template particularly that "Contact List" DB Management. That is the closest I think that...

Greaaaaaaatttttttt!!!!

The #2 is the magic solution. It's now working smoothly.

Maraming salamat po.

Hi.

I have a WebBrowser inserted in a form. When the appropriate page is displayed, that form fetch several information and do some processing. It then, move to the next page and do another...

There is an almost similar situation here: http://www.codeguru.com/forum/showthread.php?t=468069

See Post#8

Hey Xeon. What happened to that military service you rendered 5 years ago (i think that was 5 years ago)? Isnt it more exciting than IT jobs? Why not join the air force and fly F-16 instead, then...

I have here a very old post -- year 2002. Its about creating an index in the memory (almost similar to dave's suggestion):
http://www.codeguru.com/forum/showthread.php?s=&threadid=31267

...and...

I suspect you have something in your worksheet event (example"Private Sub Worksheet_Change(ByVal Target As Range))" that cancels your copy mode.

Do you have active events inside the worksheet...

Most people I personally know that have multiple degrees ended up concentrating only on one and made their other degrees an object of the flower base. Those who opted for MA/PhD ended up...