Display A Slide During A Macro Explaining What It's Doing
Jul 31, 2009
After we all spend lots of time developing a macro, we have the desire to show others who may not understand or appreciate what is going on during the time the macro is running.
What is the best way for Excel to explain/display what it is doing in "Laymens Terms" WHILE it's running? (if possible).
I was thinking of something like a slide? It would be good if the text can change at points decided by the person who put the macro together.
View 14 Replies
ADVERTISEMENT
Sep 19, 2013
I'm looking for the below requirement:
Name
Date
Sales1
Sales2
Daniel
01/18/11
4,907.00
2,038.00
[Code] ..........
Required output....
Name
Date
Sales1
Sales2
Name
Date
Sales1
Sales2
[Code] ......
Need macro code to segregate the data...
View 1 Replies
View Related
Mar 1, 2013
What can I do with this data?
In the year 2004 I designed and built my own solar hot water heater box. It works very well and saves me and my family a lot of money every month.
To understand what was going on inside and out of the heater box I purchased a commercial interface unit that consists of a circuit board interfaced to my computer via a serial cable. There is also suitable software provided by the supplier which appears to be a Visual Basic programme or something similar.
The circuit board interfaces eight sensors. These are defined as:- Input (Zero), 3.9 M, 7.8 M, 11.7 M, 15.6 M, Outlet, Internal air and External Air. The metre distances occur by dividing the entire length of the water pipe into equal distance between Inlet and Outlet.
Once the software is set up and "started" it automatically dumps the data (which I record at five minute intervals) into an EXCEL Add-in file. At the end of a day I save the Excel file and then manipulate the data into a chart which gives a picture display of all the sensors and the temperatures recorded.
I have attached a typical Excel file for one day. I try to record most days, but if the weather is overcast and no sun appears there is little or no point in recording.
I am already au-fait on how to use Excel for Min and Max temperatures and chart creation, but I would like to ask everyone how I can add a slide bar to the top of the graph to show temperature readings?
People who read this forum thread should note that once the sun starts rising (around 08.30am) then the water in the solar heater rises dramatically. This can be seen on the attached chart.
View 10 Replies
View Related
Jun 2, 2014
In the following macro, how to get the name of the chart as the slide title?
PHP Code:Â
Sub Range_Chart_1()
    Â
     'Requires a reference to the Microsoft PowerPoint Library via the Tools - Reference menu in the VBE
    Dim PPApp As PowerPoint.Application
    Dim PPSlide As PowerPoint.Slide[code]....
View 2 Replies
View Related
Dec 2, 2011
Code to go to a certain slide in Powerpoint. I kept trying to run the code in Excel VBA and it never worked.
So I said "why not try this code in Powerpoint to see if it works?' and, low and behold, it worked!
What I need is to get the code below, which works in Powerpoint VBA, to work in Excel VBA.
Code:
Sub gothere()
On Error Resume Next
ActivePresentation.SlideShowWindow.View.GotoSlide 3
If Err 0 Then ActiveWindow.View.GotoSlide 3
End Sub
View 3 Replies
View Related
Jan 17, 2014
I have a table in excel where I'm trying to hyperlink to specific side in a powerpoint presentation. I've found various sites instructing me to use #slidenumber (eg #4) at the end of the filename when editing the link, however many different combinations of slide numbers and names i use it refuses to open the deck at that set slide, always taking me to the beginning. I've tried using the bookmark option in excel but that gives a error messaging stating bookmarks cannot be used in xml files.
View 1 Replies
View Related
Feb 18, 2013
I am using an excel spread sheet as a larger display on a huge projected screen with numbers at a large charity event. It is a reverse raffle, so as your name is called you are out of the raffle. I would like to link the cell to a specific powerpoint slide which has the name and town of the specific ticket buyer. When double clicking on the cell listing their number the ticket buyers name and town would appear as a powerpoint a window in the middlle of the excel screen for all to see and then disappear after a few seconds or disappear when the next cell is double clicked. putting excel data into powerpoint slldes but not the other way around!
View 7 Replies
View Related
Feb 19, 2012
For the chart in the excel worksheets, does anymore know who to copy it to the powerpoint slide with VBA? (either straight copy and paste, or copy and paste in as picture?)
View 4 Replies
View Related
Aug 2, 2013
I am trying to write a macro that goes in an excel file that creates a powerpoint presentation, and puts four (4) charts in each slide.. I currently have a code that is pasting all of the charts in the same slide and I can't figure out why it isn't working (side note: I haven't attempted to resize or relocate the pictures on the powerpoint slides yet)..
Code:
'Add a reference to the Microsoft PowerPoint Library by:
'1. Go to Tools in the VBA menu
'2. Click on Reference
'3. Scroll down to Microsoft PowerPoint X.0 Object Library, check the box, and press Okay
'keep button in same location
Set btn = ActiveSheet.Shapes("CommandButton17")
With btn
btLeft = .Left
btTop = .Top
End With
[code]....
View 2 Replies
View Related
Oct 28, 2011
Which the best procedure to copy a chart into a powerpoint slide from a excel workbook? So that when I update the chart data in the excel workbook I can update it even in the powepoint slide ....
View 1 Replies
View Related
Apr 17, 2014
I have a userform with a command button which fires a macro.
everything works fine so far.
my problem is:
I would like to add a msgbox at the end of the macro which confirmes "successfully completed".
I cannnot simply add the msgbox at the end of the macro. don't know what I'm doing wrong.
(see below)
Private Sub CommandButtonOK_Click().
If Me.OptionButton1.Value = True Then
ThisWorkbook.Worksheets("PropertyWorksheet").Range("A1").Value = "Government Securities"
ElseIf Me.OptionButton2.Value = True Then
ThisWorkbook.Worksheets("PropertyWorksheet").Range("A1").Value = "Corporate Bonds"
[Code].....
Unload Me
Application.ScreenUpdating = False
Sheets("MySheet1").Select
Application.ScreenUpdating = False
'run macro
MyMacro1 (adds, hides and deletes various sheets)
MyMacro2
[Code]....
View 2 Replies
View Related
Aug 9, 2007
I have a spreadsheet with three sheets („Data”, „20” and „30”). On the Data sheet I have only two rows, and I do not work on this sheet. I work with the sheets 20 and 30. On the sheet 20 I need to sum up the amount of column H. But my problem is that the count of this column (the rows or cells) allways change. Sometimes there are 554 the next day 663 and so on. So I need the macro to sum up the amount of column H two cells under the last cell. I need exactly the same in the sheet 30, but the only difference is that in the sheet 30 the amounts are in the G column (not in H). Finally I need to compare the two summed up amounts (sheet 20 and 30) and they must be equal. So what I would need as macro is that when I run it, it sums up the amounts in both sheets and then in the Data sheet (in the 5th row, cell A) displays the summed up amount and (in cell B) displays OK if the two summed up amounts are equal, or just dislpays ERROR if the summed up amounts are not equal.
View 13 Replies
View Related
Mar 18, 2009
I need a macro to open when opening an excel workbook. Viz: When a workbook is opened I would like it to immediately display an 'info/warning' box with some basic advice on how to operate the sheets, once read click yes (continue) and do what is required.
View 4 Replies
View Related
Apr 6, 2009
I am trying to display a pop-up when a macro starts and display the runtime in Seconds and should close when the Macro completes.
View 9 Replies
View Related
Mar 2, 2007
I am just having a problem where at the end of my macro, the macro is looking for a value in a cell and there is no value at the end of the game for it to paste so I get an error. Instead of getting an error, I would like the macro to display, "You win!", if cell e1 is =1, "You lose!", if cell e1 is =2, and "tie game", if cell e1 is =0.
View 9 Replies
View Related
Aug 28, 2007
I have a macro that runs when the file is opened and takes some time. I turn off the screen updating to speed the process. I want a msgbox, or something, to tell users that file is processing information that does not require a response to continue the code.
View 8 Replies
View Related
May 19, 2014
I need a macro which displays the folder and subfolder name from a specific path in the column A of the excel sheet in the same heirarchy. Also whenever a sub folder name is displayed in column A, I need its main folder name to be displayed in the same row Column B i.e offset(0,1). I have a macro, but it displays the folder name in the 1st cell of column B, I need it to increment to the subsequent cells based on subfolders.
Sub Step1()
Dim startRange As Range
Sheet1.Cells.Clear
Set startRange = Sheet1.Range("A5")
'Parent Directory - Change this to whichever directory you want to use
ListFoldersAndInfo "C:desktop", startRange
End Sub
[code]......
View 3 Replies
View Related
Jun 11, 2009
I have a spreadsheet and a macro that creates a new sheet and enters some data into the sheet. The user gets to make some changes to the created sheet and then prints it out. I was wandering if there was any way to have a message coming up every 10 minutes remindnig the user about the new sheet untill it was printed out and then the warnings would stop. Could anyone sugest a good way to do that?
View 7 Replies
View Related
Jan 25, 2012
Code to have a button perform two macros?
I need the button to
1. Calculate (perform F9 manual calculation)
2. Display a msgbox (MsgBox "Enter a city or zip code to calculate mileage.", vbExclamation, "Travel Schedule")
Is there an operator that lets you string multiple macros or do they need to be recorded separately and recalled in one macro assigned to the button?
View 1 Replies
View Related
May 18, 2014
Display progress bar with percentage completion.
The below code just display macro is running without notifying user the percentage of completion.
[Code] .....
View 2 Replies
View Related
Oct 13, 2008
How can I make XL (2000) display the macro start/stop recording and relative/absolute box that used to appear whenever I started recording a macro?
Such an apparently simple issue, but I can't resolve it!
Somehow I lost this small box, and I know how to force it to display via customize, but it doesn’t seem to work the same (relative does not work as such) and the buttons or box disappear.
View 2 Replies
View Related
Jul 10, 2009
how I would display a message to the user before the workbook is closed regardless if any changes have been made e.g.
Ideally there would on be an “OK” option only by way of acknowledgement and also no option to close the message by the ‘x’ in top right corner.
View 6 Replies
View Related
Jul 15, 2009
I just finished a great macro and right at the end of deleting a sheet, I got a message box saying
"Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete"
How can I eliminate this from popping up in the middle of code?
View 2 Replies
View Related
Sep 27, 2011
I have a splash screen I want to display while a macro runs. I've created all the necessary code based on information from this site but have a question about where to actually put the code as all the example I've seen are based on workbook open events.
I tried placing my code
UserForm1.Show
with in the macro I waned the splash screen to be displayed during but that doesn't work. Well, it does, but not as I intended. The splash screen pops up for the specified duration as part of the macro stopping the macro, then closes and the rest of the macro finishes running.
Do i need to call the splash screen from a certain point in the macro I wish it to be displayed during? I dont want the macro to stop running while the splash screen is showing.
View 1 Replies
View Related
Jan 29, 2014
I am using a VBA macro (Using mouse clicks as inputs for neuroscience experiment?).
What the macro does is it inputs a timestamp every time a keyboard combination is used (alt+right arrow in this case).
The part of the macro which inputs the timestamp is like this:
Sub AltRight_Sub()
On Error Resume Next
Cancel = True
Cells(Rows.Count, 2).End(xlUp).Offset(1) = Format(Now, "HH:MM:SS")
End Sub
I would like the timestamp to be displayed as HH:MM:SS.00, i.e. show the milliseconds. I tried playing around with the timestamp format (changing it to = Format(Now, "HH:MM:SS.00" or = Format(Now, "HH:MM:SS.0;@")) or = Format(Now, "MM:SS.000") and I tried using = Evaluate("=NOW()") instead of = Format(Now, "HH:MM:SS".
View 6 Replies
View Related
Mar 21, 2007
I want to run a program from my PERSONAL.XLS workbook, however, after a piece of code
where I close all the open workbooks different from PERSONAL.XLS, the code stops running.
How can I contour this?
Down is the piece of code used to close the other workbooks and the msgbox I want to show, along with a DialogBox:
For Each W In Workbooks
If W.Name ThisWorkbook.Name Then
W.Close SaveChanges:=False
End If
Next W
MsgBox "Abrir apenas a Origem a actualizar, que deverá ser obrigatoriamente do mês corrente ou do anterior", _
vbOKOnly + vbInformation, "Atenção"
Application.Dialogs(xlDialogOpen).Show
View 9 Replies
View Related
Mar 17, 2009
Excel 2003.
I have been struggling for an hour how to hide a number to text macro in a way that only macro result is displayed in a cell.
(I have one 2-3 years old xls, where I have managed with task, but now can't figure out how and how to unhide the macro
Can it be password protected somehow?
View 9 Replies
View Related
Sep 6, 2006
Although not a complete novice, I am fairly new to EXCEL/VBA.
Is there a script that can be embedded into an EXCEL workbook that checks the Macro security of the PC, and if set to HIGH, shows a message that states that "Macro security is too high to open this workbook".
With security set to high, Excel will open my w/ book, but not run any of my checks that are set in the module. So a "catch 22" really, I need the macros to run to that it is being opened on an authorised computer etc, but if security is set to HIGH, then they don't run, similarly, if I put a macro in to check the macro setting, it won't run unless the security is set to medium.
View 9 Replies
View Related
Nov 25, 2006
I have a macro that deletes certain rows. I'd like the macro to tell me what it deleted specifically (if anything). Here's some of the macro:
For rownum = 1 To maxrownum
item = Cells(rownum, 1).Value
If item = "PUBS" Or item = "SWCDROM" Or item = "PC PACK" Then cells(rownum, 1).EntireRow.Delete
How do I get the macro to tell me if it deleted PUBS, SWCDROM, PC PACK, all three or nothing at all?
View 9 Replies
View Related
Mar 17, 2014
I'd like to create a macro to display the top 5 most frequently occurring repairs on sheet 3 of my workbook. I'd like the macro to analyse all the sheets in my workbook except for the first 3 and then output the results on the 3rd sheet from T50 onward. I have attached a template as an example of how all the sheets in the workbook look (excluding the first 3).
All the sheets have the same layout as the "Survey Template" worksheet.The repairs are located under the Log Book Review of Historical Structural Repair in the Survey Template worksheet and all the repairs are picked through a drop down list that is based on a table of repairs listed in the Parts and Prices sheet within the workbook. I have assigned random serial numbers to the repairs (if that makes it any easier to code instead of locating exact string matches).
ExampleSurveyTemplate.xlsx‎
View 2 Replies
View Related
