User Profile

Collapse

Profile Sidebar

Collapse
bg0420
bg0420
Last Activity: Aug 17 '07, 04:05 PM
Joined: Aug 8 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • bg0420
    replied to VB help with Autorun of spreadsheet
    I just hit another problem, I added another Combobox and put a bunch of code into it and it said it's to big. I guess I'm screwed....
    See more | Go to post

    Leave a comment:


  • bg0420
    replied to VB help with Autorun of spreadsheet
    I'm guessing so. I have posted the code into the VB under Sheet1 and I have to manually go into the VB by pressing F11 then I have to put my cursor next to the end sub and press F5. I'm not understanding of why I have to do that every time I open the spreadsheet up....
    See more | Go to post

    Leave a comment:


  • bg0420
    replied to VB help with Autorun of spreadsheet
    Just done it and all it did was put a date in with no working combo box....
    See more | Go to post

    Leave a comment:


  • bg0420
    started a topic VB help with Autorun of spreadsheet

    VB help with Autorun of spreadsheet

    Ok guys and gals! I have some VB code that I'm about to post, hope I don't get into trouble for posting this by my boss but I need major help! So here goes. I need this To work every time I open the spreadsheet. Here is the code can someone help in finding a way for it to automatically run?

    [CODE=vb]Private Sub ComboBox1_open( )
    ComboBox1.Clear
    ComboBox1.AddIt em ...
    ComboBox1.AddIt em ...
    ...
    End Sub...
    See more | Go to post
    Last edited by Killer42; Aug 9 '07, 03:05 AM. Reason: Added [CODE=vb] tag, shortened code to avoid trouble with your boss :)
No activity results to display
Show More
Working...