normanharker | Tue, 27 May 2008 00:06:00 GMT |
john | Tue, 27 May 2008 00:07:00 GMT |
tomogilvy | Tue, 27 May 2008 00:08:00 GMT |
michaelbednarek | Tue, 27 May 2008 00:09:00 GMT |
normanharker | Tue, 27 May 2008 00:10:00 GMT |
davidmcritchie | Tue, 27 May 2008 00:11:00 GMT |
davidmcritchie | Tue, 27 May 2008 00:12:00 GMT |
Here's the scenario: I have two forms to display on the screen: Form1 and Form2. The Form2 is displayed after the user clicks a button on Form1 (which is already displayed). Form2 is automatically displayed in front of Form1. Both forms are loaded modeless (you can't load a second form...
Can anybody explain what's going on here ? Put two listboxes and two commandbuttons on a form and partially overlap the two listboxes. The code below should alternately bring to the front and then to the rear Listbox2. Private Sub CommandButton1_Click() ListBox2.ZOrder (0) End Sub Private S...
Argh! Form controls now *always* appear on top of shape/drawing objects. What's up with that? Prior versions of Excel allows you to send Form controls behind shape objects by right clicking on them and choosing "Order->Send to back". Ok, so you're probably asking "why would you ever...
Weird zoom/view issue. We open any existing Excel file on one computer. Sheet1 is at 75% zoom/view. Sheet2 is at 100% zoom/view. Sheet3 is at 200% zoom/view. Open Excel and start a new one, and it is fine. Saves normally as well. Is there some setting that determines or sets the zoom/view like t...
Dear All, I want to be able to open the zoombox on pressing shortcut (? a free one) for all cells in column R and S . Thanks³ Filip...
I'm trying to email an excel spreadsheet to a printing shop for printig. The file is 1.88MB in size and will not deliver the email due to the file size. My question, how can I either zip or compress this file so I will be able to email it? Thanks in advance for your help. Cal...
Do not what outlook to zip my file?...
I can format the cell as text in Excel and the zeros show up and print fine, but when I mail merge into WORD, I get a zero ONLY as a zipcode. Frustrating. I need to print labels by Friday. WHat do I do?...
When doing a mail merge from excel to word zip codes starting with 0 (zero) drop the first number "0" from the address. ie zip code 01560 prints out as 1560. How do I get all 5 numbers to show?...
Every time I convert my drop ship lists from .xls files to .csv for import into UPS shipping software, the csv file drops the preceding zero on the east coast zip codes. How do I fix it?...
I can't get zip codes beginning with 0 to merge into word. If I format the cell as text it accepts the 0 but it shows in word as only a 0 and omits the other numbers. If I format the cell as a Zip it doesn't take the 0 as a first number. HELP!...
About half the records show up as a 0 in the zip code field after I merge into Word to create mailing labels. I have reformatted the column to text, tried formatting as special zip code, but stil about half the records merge as 0 zip even though there is a 5 digit zip in the Excel file...this is...
I am trying to do a mail merge using an excel data source of addresses. The zip codes appear with zeroes in the data source, but when I merge them to MS Word, the zeroes are dropped. How do I fix this problem?...
Ken- Ok, it seems i am back to square one. I have taken all of my zip codes and turned them into 5 digit (22202).. I used a formula to take the last four digits off of all the zips that had it. I then copy and pasted special/values into a new column... now some of the zips line up on the left(th...
Hi, I am a Health care researcher with the following problem: I have a EXCEL spread sheet that has zip codes of various hospitals and the number of beds in each of them. I am interested to find out how many beds there are within say a ten mile radius of any zip code in that list. So for every zi...