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!

Recent content by JUALOP60

  1. JUALOP60

    CANADA VICTORIA DAY

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

    =Row() Formula

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

    =Row() Formula

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

    DATES CALCULATION

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

    DATES CALCULATION

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

    Add a company to a combo box

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

    Combo Change

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

    Combo Change

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

    Combo Change

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

    Combine 3 cell in to one cell

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

    EXCEL LINK

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

    COMBO BOX (ACTIVEX CONTROL)

    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"...
  13. JUALOP60

    COMBO BOX (ACTIVEX CONTROL)

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

    COMBO BOX (ACTIVEX CONTROL)

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

    Index Numbers

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

Part and Inventory Search

Back
Top