Is there a way to add a time zone to an auto-format? For instance, I have a sheet that enters the current time into a particular cell when a command button is activated but my users are in different time zones across the U.S., any suggestions?
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...
Hi, Not exactly an excel question but still posting here. I want to do z-test using Excel. I do have the analysis tool pak installed (along with Analysis tool-pak VBA). Being used to Canned software (The concerned tabulation software terms it as Z-Test for percentages) which tell me automaticall...
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...
I am creating a report using excel and i want to write/find a module that makes my report open up on anyones machine using excel 2000 look the same. I want it to adjust the zoom according to the users screen setting? Is this possible? I am not sure how to do it. If anyone knows could they help i...
I am creating a report using excel and i want to write/find a module thatmakes my report open up on anyones machine using excel 2000 look the same.I want it to adjust the zoom according to the users screen setting? Is thispossible? I am not sure how to do it. If anyone knows could they help i am...
Hi, I have more worksheet in the workboock. I wish the Application in another PC - wiht different Monitor-resolution to opening. However in the sam workSheet-largeness. A.) Automatlically? B.) Via macro (Button) in the defined Zoom, for all workSheet t activate? Have I any cance? Thank you very...
Hi,I have an excel workbook with multiple sheets. It is been used on differentcomputers and I would like my workbook to zoom always to right screen width.How can I do this?I have freezed panes on top of every sheet with a background picture thathas a width of 33,52 cm. I would like to have scree...
Hi, I have an excel workbook with multiple sheets. It is been used on different computers and I would like my workbook to zoom always to right screen width. How can I do this? I have freezed panes on top of every sheet with a background picture that has a width of 33,52 cm. I would like to have...