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: *

  • Users: moswitch
  • Content: Threads
  • Order by date
  1. moswitch

    Triggering Event

    I have a private SelectionChange and Change sub routine in my VBA code which works well once initiated, the problem I have is that I am having a hard time triggering these events when clicking on the pull down arrow of a "Data Validation" List. Excel does not seem to recognize clicking a list...
  2. moswitch

    Query Oracle thru Excel VBA 2003

    I'd like to query an Oracle database through my VBA code how would I go about doing that in the simplest way possible? I would also like to assign the Where statement value by means of an Input Box, in other words I'd like to pass the value of the Input Box to be the value of the "Where" query...
  3. moswitch

    If then, elseif then, Else statement

    I have the follow Access expression which I would love to convert to a If then, elseif then, Else expression. How would I go about doing that, I'm having difficulties doing so. Return iif([A] <= "1/1/1900",year(now()) - year([B]),iif([A]="",year(now()) - year([B]), year(now()) - year([A])))...
  4. moswitch

    Cell address on Excel Graph

    I'm writing a macro to act on an embedded Excel graph, I'd like to prompt the end user to pick two points on the Graph (NOT Cell) by means of an Input Box. Once they have done so empty every Cell between those two points. I can create the subroutines for everything else except the routine that...
  5. moswitch

    Make Code invisible

    Hey guys and Gals, how do I make my VBA code invisible to the end user? I don't want to show my code. Thanks in advance.
  6. moswitch

    Command Bars?

    Hello, I'm trying to add a button on the Standard command bar in Excel, I am successful in doing so but when I try assigning a macro to the button the program fails to execute. Can any one please help? Application.CommandBars("Standard").Controls.Add _ Type:=msoControlButton, ID:=2950...

Part and Inventory Search

Back
Top