ken | Thu, 22 May 2008 23:11:00 GMT |
karl | Thu, 22 May 2008 23:12: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...
Can anybody explain what's going on here ?Put two listboxes and two commandbuttons on a form andpartially overlap the two listboxes. The code below shouldalternately bring to the front and then to the rear Listbox2.Private Sub CommandButton1_Click()ListBox2.ZOrder (0)End SubPrivate Sub Comma...
I need to change Zulu time back 1 hour due to the daylight savings time. I have a format I need to follow, which is example ?P 04:45Z? Where the P needs to remain because it signifies proposed, and the Z needs to remain, because it signifies Zulu and the time 04:45 needs to be made 03:45 while p...
How can I click on a row (or cell) and that record is seen separately on a different worksheet....
Whenever a user opens an Excel Spreadsheet the sheet automatically zooms to 400%. This happens when the user is connected to a projector or second monitor. I have updated the display driver and downloaded all MS Office Updates. Nothing else seems to be having issues except Excel and Word. The on...
I've created a data entry Excel file at work, and have placed severa text boxes on the sheet to let users enter notes. My usual scree resolution is 800X600, so this is the resolution I created th application in, and am having no problems at this resolution. However some users have their scr...
My work sheet only prints on the first half of the page width? Setup and margins don't seem to work so I can print larger. My worksheet prints out 4" wide and 2" deep. I want it to print the full page' ANy help is appreciated...
Adjusting the zoom level while viewing my spreadsheet appears to affect the formatting of the text in certain cells. For example, several of my cells have three lines of text, and when the zoom level is reduced, only the bottom two lines of text are visible. It appears as though the visible size...
I would like to know if it is possible to open a workshhet alway to the same same zoom level (i.e 94%) no matter if i am closing it to a different one (i.e 105%)...
In Word, to take the page width zoom setting and make it part of the tool bar I used Tools | Custm,ize, select the All Commands category on the commands tab, then scroll down to ViewZoomPage Width and drag it to a toolbar. Can this be done in Excel? Much thanks. -- eric...
I have a large excel document consisting of multiple pages pulling info from a dde server. I am trying to zoom the display, which I have always beeen abe to do. Today the zoom button is greyed out. I checked the protection and the document is not protected. Any ideas? Thanks...
When opening an Excel file it zooms the font only to 200% (very large). The menus are all regular size, and going into the view menu and changing the view to something different resizes the font to its correct size. I can then change the view to what is needed. Any suggestions?...