Hi Friends, I have created a macro enabled template for data entry purpose. There is a On Time Macro which schedules every 5 min and check if the system is...

Dear Members, The following is the table from where I am trying retrieve the desired data into Rank and Percentile column Marks Rank Percentile...

The workbook "Copy To WKBook.xlsm" is a saved workbook. When I enter "Range("A1:A5") into InputBox ColRngFrm prompt I get the error message per subject...

Hi all, In my active workbook, I have buttons that allow me to import spreadsheets from another workbooks located on my server. Here is the code for these...

Hi, I have a userform which is initialized as for next and add items to listbox1 from worksheets range. Now my problem is; I would like to remove item from...

Hi all, I'm running Excel 2003 and Outlook 2010. Is it possible to obtain the version of Outlook from Excel VBA? TIA,

Hi All, I want to make two lines in a excel at defined angle say x degrees that depends on a cell value. So, its not hard to convert this value to...

No time component, just the date. This seems a bit much. Is this how it's done? Dim dt As Date: dt = Now() Dim justDate As Date: justDate =...

I made a few copies of Sheet1 by right-clicking the tab and choosing "Move or Copy", followed by "Create a copy". Next, I added one one Button control on each...

So, I'm trying to sort a specific way. Here is what I have. Cells.Sort Key1:=Range("C:C"), Order1:=x1Descending Unfortunately, there are at least a dozen...

Ok, I created a userform with three comboboxes. The drop down has all of the data I need it to (from another tab), such as states, colors, etc. It's set up...

I'm using onTime() for the first time. I want to insure that no modal will stop the scheduled job. Can you do this? sub scheduledJob() ' Turn off all...

We use Excel 2010 and the majority of our programs are "macro enabled" files. This means that each new user on our network must manually enable macros by...

i need to count how many times a word is in string in the same cell so is their way to do that either by funtions or macros

I am having difficulties getting my macro to work properly. I have a sheet of data that I am updating with NEW data each month (overwritting the previous...

How can I get the cursor to move right upon inserting a digit from 1 to 9 in a cell using VBA without having to press enter or return

HI, I need to capture the initial value of a cell into another cell and store it permanently even if the parent cell value is changed any number of times. For...

Hi all, I have a macro that prompts an input: Dim TheAnswer$ TheAnswer = Inputbox( Etc. etc. You get the gist. Anyway, it takes the input but doesn't do...

the message appears when i decide to exit from the workbook. i work in excel 2010 (with 2007 i haven't the problem). The file is on the network, in one server...

Hi, I need some help with this macro. When I run it I get the yellow explanation mark on some cells in column D which I formatted as text. It says a date...