Search results for query: *

Hi, how to calculate victoria day, with a formula in excel? here are the details: has to be Monday before May 25th. Thank you

Hi, I have a combo box with on list name "CustLookup1" with column A with Index numbers using =row() function so when I add a new company will also increase or assign next number. The problem is that When I select a company from a combo box first switch to the database and start blinking like...

Hi, I have a combo box(Activex control) with ListRange of Payable Database, when I select a company populate address/city etc. fine, but since i have an index column to i created by adding formula: on cell A2, =Row()-1works fine but now every time i select a company from the combo box it...

Hi, This is what i have, on sheet i want by the dates to know which payday period fall on vacation days taken. EMPLOYEE NAME: JOSE I #VALUE! #VALUE! DEPARTMENT: ACCOUNTING #VALUE! #VALUE! Wednesday VACATION START DATE: June 16 2010...

Hi, I have a formula: =Networkdays(g16,g19) on H20, my problem is this, From this above results I want a formula and cell h25 also to calculate in which payday are those vacations days fallen. Our period is like that: from 8-24 is pay on first day of next month, from 25-7 is pay on...

Hi, I am about to finish an application in excel 2007, I have a combo box which list companies and when i select the address/city/code get populated nicely. I created a name range to use in the combo box (Activex Control) but it will not work i have to say the range for example...

Thank you. You were right dhookom I didn't need a code, just needed to put list width number in the combo box. Thank you again

Sorry, I forgot to mention, Excel 2007. thank you

Hi, How to make combo box size to chane when click arrow, and then go back to normal size? will this code work: ComboBox1.Width = 200 how to get it back to normal size one i select the item. because the way it is now i can not see all columns only if I scroll to the right. thank you

Hi, i have this code: If Range("A" & LRow).Value = LINDEX Then LFound = True LCompany = Range("B" & LRow).Value LAddress = Range("C" & LRow).Value LCity = Range("D" & LRow).Value LProvince = Range("E" & LRow).Value LCode...

Hi, I have a file in excel link to 2 files. Let's say the file name is payroll.xls but i want to save a copy payroll-5-10-98 to keep a copy of that period. but what happens is that when i open the file it updates to current figures. I want it to keep the figures for that period so i can...

Hi, i use this code to call the "PopulateData" macro: Private Sub Companies_Open() 'Macro purpose: To send the user to the home range Call PopulateData End Sub but now i am getting this message: run time error 1004, method range of object_worksheet failed. The "PopulatedData"...

Hi in Microsoft excel. To call a macro in payable sheet in same workbook thank you

Hi, Thank you very for your responses. I created the sub procedure to call the macro but I am getting the error couldn't find the file, check the speeling etc... (But the spelling is right). error "1004". Here it's the code: Private Sub Companies_Change() Dim XL As Object...

Hi, I have a vendor database in excel, columns: Index Company Address City Code so to use Combo box (Activex Control) i need to have an index number, to update the combox when i insert a new company, i need to update the combox and increase to the next index number automatically, I am...

Hi, how can i make this code work in Combo Box (Activex Control) to populate data fields in excel? I got it to work in Combo Box (Form Control) but it will not work in Combo box (Activex control). The reason I want combo box (Activex control) is because you auto complete can display more...