I am writing some VBA that changes the value in a control toolbox combobox,
but I don't want it to run the code assigned to changing the combobox ( it
clears it runs some other code and then changes it to a different value).  I
therefore disabled enableevents, but it is still ...

I have created a custom function with 5 possible arguments.  Is there a way
to have the "IntelliType" feature work with custom functions where the user
is prompted for the list of required arguments for the function?

Could someone help me with some sample code for this:
I have rows of data in a sheet with the Date/time in the first column (five
columns total for each row of data - including the date/time column).
I need to copy the data into a 7-day weekly calendar format with the time

Please could somebody tell me if it is possible to call a macro from an if()
function
eg if (condition true, macro1,macro2)
I am thinking not, but ....?

I have a table with two columns, column A contains old values  and column B
contains new values.
I am trying to create a program, where I paste a piece of text into a
separate worksheet, which contains old values (can be randomly within the

I'm new to excel vba. I'm tried out the vba code for changing cells
color but it don't work if my cells contains a if formula (eg. all
cells in cloumn A contain =if(and(b1="Rej",c1="Rej"),"Rej",....). Any
idea what should be the code?

HI I have a spreadsheet imported from a csv file . In column A I have a list
of stock numbers which are 6 digit numerals. The file also has header columns
and page headers etc which I need to remove so that I have a straight list of
stock reocrds only to be able to sort etc.

I'm using the filesearch function for the first time.
When I run it several times (always in the same directory and with the
same files existing), it happens that it works properly for some times,
then it stops working and there is no way to make it working again.

I am having trouble with autocomplete that has stop working in the IDE
while coding. Then it will suddenly start again for a while, before
stopping...
I have tried restarting excel and the PC but no joy

I have a worksheet which displays a list of items in column N based on the
user input in cell C5.
What I want to do is allow the user to click on any of the cells in column N
(without the possibility of accidentally editing them) which will then run a

I have the follwing code which sets a formaula in a specific column
   With Margin
       .FormulaR1C1 = "=SUM(RC[-1]-RC[-3])"
           '.Value = .Value

Hi there,
I am trying to get the timestamp to function, so that if C3, fo
example, is blank then blank, else show timestamp.
I think the code must be entered on "ThisWorkbook"?

Is there an easy way I can use VBA to get a list of foldernames in a spesific
folder?

I cannot get Countif to return the number of periods in cell A1
(formatted as text) :  "1.1.1.1"
Thanks for your help
Cheers

Is it possible to specify the manual feed tray when using the printout method?