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!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. elohelae

    Listbox with Multiple columns

    That was it, thank you
  2. elohelae

    Listbox with Multiple columns

    Hello I have two listboxes Listbox1 and listbox2. I used the code below to insert an item from listbox 1 to listbox 2. Listbox 1 has 2 columns and i want to copy both columns to listbox 2. How do i modify the code below to copy both columns? I appreciate any assistance. Private Sub...
  3. elohelae

    Linear regression using dates in excel and access

    thanks for the reply, the built in function does not handle the date field. i do not want to go through changing the format of the field back and forth if i can help it to accomodate the function. that process is relatively easy in excel, not so much in msacces when doing queries. However i will...
  4. elohelae

    Linear regression using dates in excel and access

    Good afternoon. I have been using the slope, intercept and linest functions to help me with linear regression and have been using the dsimpleregress function in msaccess. Everything works great for numbers, however i have a set of data where the x access is dates. The function does not seem to...
  5. elohelae

    Excel Checkbox code issue

    Skip perfect, thank you for your patience and your help with this. cheers
  6. elohelae

    Excel Checkbox code issue

    Skip I have a sheet which I want to place the checkboxes in, however I want the true / false recording of this data in another sheet called MyCalc in the same workbook. I used the above code to correctly link the checkbox to the cell in which the checkbox is displayed, however I need this link...
  7. elohelae

    Excel Checkbox code issue

    Skip Thank you for your response. The code works correctly when the cells are selected, however it stores the true / false value in the same cells as the checkbox. My goal is to save the true / false value to a linked cell in another sheet, that way I can process the information and go from...
  8. elohelae

    Excel Checkbox code issue

    Hello I used the code below to enter multiple checkboxes in an excel 2010 sheet. I need to alter it to link to cells with the same reference but in a different sheet and I cannot get it to work. The name of the sheet is MyCalc Please can you help? The code is below and any help would be...
  9. elohelae

    E&M connectivity

    Mitelmania Thank you for the response. I have limited access to the isdx offshore, so i cannot make hardware changes. I am looking to do this change on shore with putting in the mitel. do you have any experience with a switch outputting e&m with a serial port, then connecting to a mitel with...
  10. elohelae

    E&M connectivity

    Once again, thank you. Ive looked at the options surrounding the per and dsu nodes but it comes back to the issue that i need the serial interface along with the E&M cards. It is looking like a forklift job unfortunately. have a great weekend.
  11. elohelae

    e&m apnss

    Good morning I am looking for an e&m APNSS card for an isdx micro, does anyone have one for sale or know where ic an find one?
  12. elohelae

    E&M connectivity

    All Thank you for responding, the issue is not the E&M ports it is that the signalling is controlled by the serial port interface, and thats the kicker. On the siemens it is acting like a d channel. I need th mitel equivalent and i suspect it does not exist. Thank you for looking, if you have...
  13. elohelae

    e/m solution for realitis

    Good afternoon I have an old siemans islx on an oil rig and onshore i have an old realtis phone switch. They are connected using 12 E&M trunks with a separate serial connector for signalling. Acting as the carrier are two cisco routers at either end which provide e/m tunnels to the far end...
  14. elohelae

    E&M connectivity

    Good afternoon I have an old siemans islx on an oil rig and onshore i have an old realtis phone switch. They are connected using 12 E&M trunks with a separate serial connector for signalling. Acting as the carrier are two cisco routers at either end which provide e/m tunnels to the far end...
  15. elohelae

    VMware session not seeing network

    I have a vm workstation server running on ubuntu. I have a session running redhat with cisco cucm 8 attempting to install. I have a router, laptop and vmserver all able to ping each other. Where it falls down is that i have given my redhat application an ip address on the same subnet but it...
  16. elohelae

    Active worksheet help

    Good afternoon I previously copied this code to get help with printing of multiple charts. The code works great however I would like to change it to just print off the first sheet which has the print macro button located on it. This print macro should now just run this code on the page with the...
  17. elohelae

    print excel charts from macro

    Skip Thank you for the advice in response, the code prints out exactly what i need except it does it in portrait instead of landscape. so i just changed the chart type individually and it works now. thanks for your assistance, your code was helpful.
  18. elohelae

    print excel charts from macro

    I found this code and it works great dim ws as worksheet, co as chartobject For Each ws In ActiveWorkbook.worksheets For Each co in ws.chartobjects co.chart.printout next co next ws however I have now been asked to print them landscape and also now can they have 2 charts per page...
  19. elohelae

    print excel charts from macro

    Hello I have an excel dashboard with 10 charts on it and I have now been asked to place a button on the chart which when clicked will print out all the charts on individual sheets. What is the best method to go about this? Any good advice would be appreciated.
  20. elohelae

    Excel chart print from Dashboard

    appreciated, thank you

Part and Inventory Search

Back
Top