Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AMCCoder

    Design Change Not Taking

    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...
  2. AMCCoder

    Design Change Not Taking

    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
  3. AMCCoder

    Design Change Not Taking

    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"...
  4. AMCCoder

    passing data

    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...
  5. AMCCoder

    passing data

    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...
  6. AMCCoder

    Checking the undo buffer

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

    MS Project 2003 Macro Help Needed <URGENT> !!!!!

    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
  8. AMCCoder

    returning the row number

    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...
  9. AMCCoder

    Excel saves to temp and then deletes the original, what's wrong?

    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...
  10. AMCCoder

    Excel worksheet macro - Changing Name of File causes ERRORS

    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...
  11. AMCCoder

    Checking the undo buffer

    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...
  12. AMCCoder

    Replacing strange foreign characters in Excel 2000 VBA

    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...
  13. AMCCoder

    BeforeDoubleClick Event not working

    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
  14. AMCCoder

    BeforeDoubleClick Event not working

    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...
  15. AMCCoder

    BeforeDoubleClick Event not working

    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...

Part and Inventory Search

Back
Top