ragdyer | Wed, 04 Jun 2008 20:03:00 GMT |
debra | Wed, 04 Jun 2008 20:04:00 GMT |
Is there a function in Excel to calculate Z-score? Is this the same as Z-Test?...
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...
Here's the scenario:I have two forms to display on the screen: Form1 and Form2. The Form2 isdisplayed after the user clicks a button on Form1 (which is alreadydisplayed). Form2 is automatically displayed in front of Form1. Both formsare loaded modeless (you can't load a second form if th...
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...
Hi Ron,Yes please post an example. I tried to combine two VBA examples on your website but was not successful.I am using WinZip.Thanks a lot for your help.Regards,Martin"Ron de Bruin" wrote:> Hi Martin> Create a workbook with only the sheets you want with code> and save/zip that workboo...
Hi Ron, Yes please post an example. I tried to combine two VBA examples on your web site but was not successful. I am using WinZip. Thanks a lot for your help. -- Regards, Martin "Ron de Bruin" wrote: > Hi Martin > > Create a workbook with only the sheets you want with code > and sav...
Hi all, I am after a little bit of help with a zip problem, I have had a look around the newsgroups and have found the relevant code that is used to zip a file before emailing using winzip, the problem that I have is that I dont have a registered copy of Winzip so the zipping process keeps falli...
Hi all,I am after a little bit of help with a zip problem, I have had a look aroundthe newsgroups and have found the relevant code that is used to zip a filebefore emailing using winzip, the problem that I have is that I dont have aregistered copy of Winzip so the zipping process keeps falling o...
I have a spreadsheet being used to merge addresses into letters and labels. The column containing the zip codes are all either five-digit or five-digit+four with no dashes to separate the five and four digits. Can someone please tell me how to insert this command into the spreadsheet so that the...
Hi! When I mail merge address info from a spreadsheet, the last merge field--empty zip code--does not close up. I have two zip code fields: one for physical address and one for P. O. Boxes. The last field shows up as a zero when empty. I tried setting the options by unchecking zero, but that doe...
when I enter a formula in a cell it displays a 0, when there is not an answer to the formula. Is there a way to keep the formula but get rid of the zeros any help is greatly apperciated! Thanks, Darrell...
While trying to imput data into my worksheet the sheet is constantly removing my zeros. Such as the number 1200 turns into 12. This is only happening on my computer so I am wondering if maybe one of my settings may be off. Please any help would be very much appreciated....
How can I format a cell to not show the result of a formula as being a negative zero, ie (0.00)? This does not happen with all of the cells only some....
I have my setting checked to display zeros, but it still displays as a dash. I am new to Excel, but not spreadsheets, but I can't figure out why this is happening. Please help. Thanks....