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...
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...
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...
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...
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...
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...
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...
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.
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...
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...
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...
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...
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...
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.
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.