Search results for query: *

Mastakilla, Yes, all of the controls' visible property were set to TRUE. Here's the wierd thing. I deleted a control, which caused my build to fail (a load function writes to that conrol). When I used the UNDO command to put it back, my form built properly with the changes made! Would using...

Sorry, There's no code to move around the elements. On a whim, I went back and tried to modify a "Hello World" form. Still, when I moved the elements of the form around, the end result was the same as if I had done nothing at all. Joseph

Hi, I hoping someone can help me with a stupid question. I created a form, wrote some code for it, and got it to compile and work just fine. However, I wasn't happy with the design of the form, so I moved some elements around: a webbrowser and a panel. When I clicked on the "Start Debugging"...

Yeah, I really should read these things before I post... The line should have been [i]Just like the Microsoft Wizards, would it not be possible to make each of your current userforms into a separate tab on a userform (in a tabstrip or multipage), and then use a Next button to cycle through...

I don't yet know how to do this on a userform, but why not use one userform with several tabs? Just like the Microsoft Wizards, would not be possible to make each of your current userforms into a separate tab on a userform (in a tabstrip or multipage), and then use a Next button to cycle...

Hey, thanks. The arcicle looked like it had some very promising information Joseph.

Does Project 2003 have a Visual Basic editor like Excel and Word? If so, you might be able to record a macro, and then look at it's code. Once you know some of the syntax, you might be able to check the VBA help for some keywords. Hope this helps, Joseph

This answer only applies if you are trying to code a macro. It does not apply to a situation where you would want to use a user defined function to display the active row number on the worksheet (as in "=ActiveRowFunction()" as the formula in a cell). Try searching the VBA help with the search...

I may be confused about what exactly is happening to your Excel spreadsheet. If I understand correctly: you have created an Excel workbook; in the VBA code for this workbook, you have created the macros; after creating them, you attempt to save your workbook. At this point, Excel gives you...

There are a couple of assumptions I will make in this post, so please forgive me if I assume too much and fail to answer your question. I also know nothing of your level of expertise; again, please forgive me if my explanation is a little verbose. My guess is that you created a toolbar - not...

On a similar topic to this, I have had a few questions about the undo command. A few times, I have made some changes (that could have been undone before running a macro), run a macro (a sub, really), and then realized that I wanted to change that first bit of data. However, I've noticed that...

I've never had much luck with strings and the Chr(#) function, but I think it may help you here. I do most, if not all, of my VBA in Excel, but here's the info I have. I think the best way to do this is to determine the UniCode character number for your special character. I'm sure there are...

Thanks a bunch. Now I just have to search code on several workbooks to find out when I forgot to set EnableEvent to True... Thanks, Joseph

Well, I just found the answer to my question. Apparently, the "EnableEvents" property was set to false. Does anyone know if this property's value remains set even after Excel closes? Does Excel (Office, etc.) not defaul this value to true on opening a workbook or starting the application...

I am trying to use the beforedoubleclick event in a worksheet, but I cannot get the event to trigger. Any assistance would be greatly appreciated. I am using a simple function just to see if the event is triggering. This function is in the code for the worksheet I am trying to use...