Search results for query: *

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

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

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

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

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.

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