I am trying to get the first column to float down as you scroll down the spreadsheet to fill in information. How do I get that going. I can't figure it out.
I use excel 08, computers viewing the files are 03.
Workbook 1 has 2 spreadsheets. Spreadsheet 1 contains Item and Pass/Fail Columns. under the item column is the serial number of the item tested. the Pass/fail column has the serial number duplicated if it failed tested. what is the formula is to have spreadsheet 2 pick the items from the pass/fail column on spreadsheet 1?
View 4 Replies View RelatedI have two spreadsheets, one gives me the beginning and end of civil twilight as a measure of day vs. night. The spreadsheet has Date/Time in the first column, and the value 45 in the 2nd column when it is night. The second spreadsheet has also 2 columns with date/time and body temperatures of a squirrel. I want to get basic statistics (mean and standard deviation) of the squirrel's nocturnal body temperature, that is for times when it is night (value 45). The tricky part is that Date/Time of both spreadsheets are different. The procedure has to recognize that the date/time of body temperature lies between the beginning and end of the value 45 blocks of the first spreadsheet.
files: twilight sheet squirrel temperature
I have a textbox that constantly shows the contents of cell B1, a changing cell, as it is a total formula (to make my textbox display the contents of cell B1 I clicked on the textbox and then entered =B1 in the formula bar).
Trouble is, my textbox scrolls with the rest of my sheet and soon disappears from the screen. I need it to float on the screen and remain always visible when the sheet scrolls far up or down. How can I achieve that?
Or is there any other floating object that will constantly display the changing contents of cell B1? I’ve tried a textbox within a UserForm (which does float and remains always visible) but I cannot make that textbox display the contents of B1.
I wish to have a floating link in large spreadsheets that will always be visible and when clicked will return to a particular cell in that same spreadsheet.
View 2 Replies View RelatedIs there any code available for a floating Message Box instead of Standard Message where by the user can scroll the sheet and decide to choose "Yes" or "No".
View 4 Replies View Relatedif it is possible to create a floating Tab like you get on websites, so ehwn you move the spreadsheet to the left or right, the tab/shape with words in moves with you.
View 8 Replies View RelatedI was asked by a co worker if there is a way to make a data table float b/w tabs or in other words, it would always be visible no matter what tab or location you are in a workbook.
My first answer was no, that he would need to create that table on each tab and freeze the panes so that it was visible no matter where he was in his workbook.
cell A1 contains the numeric value: 3961.3
cell A2 contains the follwing: ="z equals "&B3-3933.7
which i would expect to give me: "z equals 27.6"
BUT, it gives me: "z equals 27.600000004"
which is awefully strange becos the 4 comes form nowhere...
what makes some sort of sense is that if the value in A1 is changed to 3961.4 or 3961.5, then the final decimal 4 in A2 changes into a 3, and then a 2.
when the value in A1 is changed to xxxx.7 the number in cell A2 becomes what one would expect it to be.
how do i get rid of these strange decimals???
(formatting cells, setting number of significant figures does not work. i naturally already tried that)
I want to create a floating window in excel that can contain a series of macro buttons (12 total)
I'd like to see if this window can be opened with a hyperlink or a single macro button on a spread sheet.
See here:
http://www6.uniovi.es/~antonio/uned/...-754hex32.html
This site allows me to enter a 32-bit Hexadecimal Representation and get Decimal Floating-Point result.
For instance, 4224A012 gives me 41.2.
Is there a UDF available to do this inside of Excel?
I have a dataset that looks like this ....
View 9 Replies View RelatedI have created a chart in a chart sheet (using VBA) - all well and good. Now I notice that if I place the mouse pointer over any of the pie slices, I see text similar to the following
Series 1 point "Swedbank" Value: nnnnnn (n%)
Now obviously (?), the name Swedbank is from the source data and the nnnnn (n%) are the values to be plotted. I'm wondering 2 things Can I "format" that text in any way, for example, so it shows Swedbank, value: nnnnn (n%)If I can, can I also format the numbers so that'll end up something like 1 234 567
How would you set up a macro to delete numbers in a spreadsheet in one column that appear in another column or worksheet?
In other words, if I have the numbers 1,2,3,4,5,6,7,8,9, 10 in one column and in the same column, or another column or worksheet I have the numbers 1,2,3,4,5 - I need a way to delete 1,2,3,4,5. I know how to delete duplicates via the advanced filter but I want to have the duplicate and original deleted.
I was wondering if it is possible to hide a column(s) but still have data in that column be visible at the bottom of the spreadsheet. For example, if I hide column G can it only hide the column from rows 1 - 50 and then the column will appear after row 50?
View 3 Replies View Relatedis it possible to display the files open (the contents of the Windows drop down menu from standard toolbar) in a display that can be viewed at all times on a workstation. My reason for this is to monitor the files I have open to avoid trying to open a second copy and getting error reports from macros within. These error reports seem to frighten some of the users here and rather than read them and act accordingly they go for coffee and say thier system is down. It is my intention once I can get a system working, to introduce these people to monitor what they already have open, and more importantly what they do not need open at any particular time.
View 13 Replies View RelatedHOW TO SET FLOATING COMMAND BUTTONS in sheet which fixed at top or bottom of the screen not fixed at cells
means while scrolling a screen it should look like fix at bottom of the screen
i have a userform which displays a textbox which shows a variance in price terms based on a sheet which has live data via dde.
I would like to turn this userform into some kind of floating monitor if possible. At the moment - once you fire up the userform - the price in the textbox is fixed and does not change with the cell which fills the textbox on the userform. The only way is if you close the userform and re-open - then you will see the current price. I would like to keep this userform floating so that you can still select other cells on the sheet.
Is this possible?
Private Sub CommandButton1_Click()
Unload Me
End Sub
Private Sub UserForm_Click()
End Sub
Private Sub UserForm_Initialize()
With ThisWorkbook.Sheets("price").Range(ActiveCell.Address)
If .Value = "" Then
Range("D31").Select
Me.TextBox1.Value = "No Trade Selected"...................
Is it possible to display all of the bars from a floating bar chart on the same line. The effect would be a single horizontal bar that turns "On" and "Off" from left to right. I'm not sure of the application, but it might represent when a room is occupied over time. I think one can create this effect using Andy Pope's "Column Chart with Varying Width Bars" charting technique (provided on his web site http://www.andypope.info/charts.htm ), but is there a more direct approach?
View 5 Replies View RelatedNeed to code to create a custom floating menu which appears on opening the workbook. It works brilliantly, but I'd like to adapt it so that I can create a floating toolbar, which is fully expanded upon opening, where the button faces are plain text which I designate. Let's suppose the macros I want the buttons to trigger are called MacroA and MacroB, and that the text on the buttons should read "Do A" and "Do B".
Sub Create_Menu()
Dim MyBar As CommandBar
Dim MyPopup As CommandBarPopup
Dim MyButton As CommandBarButton
Delete_Menu 'make sure commandbar isn't already running
Set MyBar = CommandBars.Add( Name:="My Menu", _
Position:=msoBarFloating, temporary:=True)
With MyBar
.Top = 175
.Left = 850
Set MyPopup = .Controls.Add(Type:=msoControlPopup)
With MyPopup
.Caption = "My Tools" 'change to suit....................
I am trying to create a floating bridge bar chart.
Here is my data and I will try to describe as accurately as I can.
FY 2004 operating margin = 14.6% (while FY 2005 and FY 2006 = 11.2% => So the difference is 340bps)
The "bridge" back to 14.6% = 90 basis points for Jimmy'Z, 30 basis points for stock option expense, 30 bps for marketing -- that's 150 bps of the 340 and I'm trying to quantify the rest of the bridge but is there a way to show this in excel with floating bars - that is to say the 14.6% bar will touch the axis but the other 3 data points are not touching the X axis but are in the air in a step formation... ?
Why the following (do it in the immediate pane) gets the wrong answer in VBA.
[Code] .....
this should return 0.1 but what you get is
9.99999999999996E-02
convert a decimal number entered into a cell into its hex representation? 32-bit floating point representation.
View 10 Replies View RelatedI've created a Pivot Chart in which I want to display travel by various folks to mulitple sites. The Site field is a Page field. If I set the Pivot Chart to a Custom -- Floating Bar style it displays fine, but if I change the Page field selection the chart reverts back to a stacked bar style.
I've tried setting the default chart type to Floating Bar (this doesn't take), and naming a custom style that is Floating Bar (and setting the pivot chart to this custom style -- but again the style does not hold on a change to the Page field).
I ran into this a few years ago and wrote some event macros to reformat the chart when the sheet is activated and when it calculates, but it seems there should be a simpler (built-in) way. Am I missing something obvious? Is there a way to make the Floating Bar style stick in a pivot chart without resorting to VBA updating?
Is it possible to refer a floating text to a specific cell in a worksheet?
View 3 Replies View RelatedI want to make a "return" button that follows the user from the start sheet to other sheets and acts as a "return to the start sheet" button. I tried just recording a macro and cut/pasting the button from one sheet to the next, but apparently when you do this the button name changes.
View 6 Replies View RelatedIs there a way to put a floating date range in the criteria much the same as can be done in excel ie greater than Today() but less than Today()+3? I don't want to keep going in and adjusting the query if I don't have to and if I don't keep the range tight there is too much data.
View 9 Replies View RelatedI have a byte array that contains a 4 byte floating point number. How would I convert this byte array to the single typed floating point number it contains?
I need to calculate a Stdev and Average based on a specific range. However, my range is not constant in the time. For instance, today I may need to calculate these functions based on 30 numbers, but tomorrow on 25 or 15 or 50...
Is there a way to automate this process by changing the number of data points to include in the range in one single cell and avoid manually adjusting the range in accordance with needed data points?
In other words, I would like to change the value, let's say in Cell A1 from 30 to 50 and then Excel would re-calculate the StDev and Average based on 50 data points and not 30. Is that possible?
I have created a custom floating toolbar that works perfect (thanks to all the reading on here!). My workbook is a stand alone estimating tool that many users will have a copy of.
I have two things I want to do yet but I cant find it on here.
1) My buttons on my toolbar - I want to have custom icons. I can do this temporarily but when I exit my worksheet and re-open they are lost. Is there anyway to save a custom icon. I am willing to add it to the icon list if necessary and then when users open the workbook copy the custom icons onto their computer. But I am not sure how/where I could do this.
Worse case, can I color my button text?
2) When my toolbar appears, it is wide, all buttons are going left to right. I want the size to be small width so the toolbar buttons are on top of each other. Any thoughts? I tried adding a .width but it didnt work.