Tip Messaging (pop-up Like Window Perhaps)
I am using Excel 2003 and wish to make a tip message (pop-up like window perhaps) if a value of a particular cell is exceeded.
View Complete Thread with Replies
Related Forum Messages:
Yes/No Pop-up Window
I have a certain macro which copies data from one file to the other. There are several target files (refering to a given month each) and one source file. The user chooses a month from a drop down list in the source file which modifies a certain cell. The value of this cell decides on which of the 12 target files will be opened to paste the data to. The macro also copies the value of a cell which refers to the current date (=TODAY()) This number is then compared with a the range (value between two pints in time: start and end date of a given month). All I need is some sort of a pop-up window with a header i.e. WARNING. and the window text: You are about to send the information to a file which does not refere to the current month, are you sure you want to perform this action" and two buttons YES and NO in case the value of the current date does not match the range set up by the starting and ending of a given month in the target file. The button YES would then do waht ever the code that was placed before the pop-up window said, save the aplication and close it, and the NO button would simply close the aplicatiown without saving it. Something like that:
'the whole code describing the action to be taken
If Range("A1").Value >= Range("A3").Value And Range("A1").Value <= Range("A2").Value Then
'here the A1 cell refers to the current date and cells A2 and A3 to the start and the end date of the month
Customizing Debug Pop Up Window
If a user decides to hit the esc key right in the middle of one of my procedures (bug free, etc), this will leave the file in an odd state. The file is set up so if the routine is re-run it cleans the file up and restores it to proper form.
But hitting esc exposes my code which is password protected when the file is idle. I employ a little trick that makes it hard to hack into my worksheet code, but one achilles heel is the esc button.
What I want is to have the file close if the routine is stopped in mid stream. This way the code is not exposed, and the user cannot monkey with the file.
I wanted to set the file up where i have a custom debug window that when a button is pressd the file closes OR when the user escapes out of the debug window the file closes as well.
Macro For Pop-up Window With Picture
A macro, which would allow me to click on a particular cell, which will have an ID number (1 through 34), each ID# is attributed to a particular employee. These ID# are located in my spreadsheet in columns B & G, and the ID #'s begin initially in B6 & G6 and continue downward to B34 & G34. These ID #'s are used in a vlookup type formula which covers 35 pages of this workbook. What I'd like to do is be able to click on any cell between B6& B34 (and/or the same in G6&G34), which has a particular ID # in it and have the photo of that particular employee designated with that ID# pop up in a window generated by the macro. I hope this makes sense! Any help would be greatly appreciated. My 1st sheet in my workbook is my "lookup" tab, which contains my ID# list and numbering sequence affiliated to each employee. So I'm not sure if I'd need to put the photograph of the employee in a column next to the employees name or have a folder designated with all my pictures in a certain directory, etc.
Internet Explorer Object AND Pop Up Window
I have a VBA project that navigates to a website and then clicks on a link. When I click the link in my code a new IE Browser opens with a form that I wan to fill out. I know how to update the form, but I don't know how to reference the new browser window that was opened when I clicked on the link.
'Open End User Multiple Selection
Set tags = myIE.document.getElementsByTagName("A")
For Each tag In tags
If InStr(1, tag, "'multiple_selections.htm','EndUser'", vbTextCompare) > 0 Then
when I try to reference the document in the popup window, it is still referencing the previous window. How can I set my "myIE" object to reference the new pop up window?
Creating A Pop-up Window With Specific Cell Data
I'm basically creating a file where a userform comes up when you open the workbook, blocks the access to the actual workspace so that no manual entry can be done. What the userform allows you to do is add a new entry to the database (the userform has some text boxes where we type in stuff like location and name or age) after having found the next empty row in the enormous database (3.000 lines)
After having clicked the OK button in the userform and added the data to the database, I would like the userform to have a pop-up message box with specified text like:
"The number assigned to this entry is:" and then I would like to add a variable with excel using the cell in column D of the same row of the new entry. So the end result would be :
The number assigned to this entry is: 01
Custom Messaging With Mouseover
I have a worksheet that contains 5-6 bar charts on it and I am trying to display additional data to the user whenever the mouse hovers over one of the bars.
I found a really good start at:
And it works perfectly whenever the chart is in its seperate 'Chart' tab, but I can't figure out how to make it work when the charts are in a worksheet instead.
Prevent Display Of Hyperlink Screen Tip
I'm working with text boxes in Excel that have hyperlinks attached to defined names on a worksheet. Basically just to navigate around a large sheet.
They work fine, but when the mouse is hovered over the text box it automatically displays the address of the defined name, which looks messy and I want to get rid of it.
I have tried inserting a single space in the screen tip box, but that displays a small rectangular box. I have also tried "" hoping nullstring maybe interpreted as not to display, but it instead displays the speech marks.
Has anybody done this before? I've seen it done, but I have no idea how the model creator did it.
Stop Tool Tip Flicker On Mouse Over
In my application threr are command buttons. it is required that as the user place the mouse pointer on the button a tool tip should be displayed which describes the functionality of the button. i have used a lable and its default visibility is set as false. In the mouse move event of the buttons i am making the visibility of the level true. Its working fine but my problem is due to mouse move all the buttons and an image in the sheet flikers. so how to avoid the flikering? Is there any other method to display the tool tip with out using the mouse move event.
Hyperlinks: Extract Display Text & Screen Tip
a) I wonder if I can copy this link out without keystroking each row.
b) When I point at the link, a few numbers come out. I want to extract these number out.
I am thinking of creating a macro so that it can be performed automatically because I have more than 300 rows.
Show Cell Value(text) In Comment Box Text, Or Mouse Tool Tip On An Gif Icon
I have a spread sheet were the area is getting very limited. I need to insert a small icon and when the mouse goes over (like it does in a form tool tip) will show the value of a cell (text value) located in another sheet in same workbook, or I was thinking inset a comment next to the icon and link the comments of the comments text to cell with the text value.
I've look the properties of this to objects and can figure it out.
Tip To Show 'last Saved' Date On Worksheet
how I can have the latest date a file was saved showing on the worksheet? For example, I open a worksheet that was last saved on Sept 22nd, and after updating it today, I save it and want the date to show today's date?
I'm pretty sure I've seen it in some files in my working life, so would appreciate advice on this!
Closing Immediate Window
Is there any way to have a macro, that is started from the immediate window, close the immediate window when it's done. My macro closes the immediate window, but as soon as it ends, the immediate window reopens and my cursor is inside it.
New Window On The Taskbar
i was recently upgraded to Excel 2003 and have found that whenever i open more than one workbook, it opens in a new window on the taskbar (similar to opening another application)... I remember having this in my previous version of excel but i can't for the life of me remember how i switched this off?
I open up Excel by double clicking on a file, it opens but it just has a grey background and the file I opened is displayed as a small 1 inch stip in the top left - just a title bar with the windows maximise, minimise and close buttons.
What ever I click I can't see any of the cells!
There is a column with a formula and a list validation, and an adjacent hidden column with numbered ids. When moving into the list validation cell the Worksheet_Selection_Change event code saves information about the Target cell - value, address, formula. When a value has been obtained from the list the Worksheet_Change event code looks up a belonging id in a lookup table and put this in the hidden id cell, and puts the saved formula back into the list validation cell. This makes the sheet (or window) unmanagable.
When I move around the sheet I can see the cell name in the Name Box, but the sheet itself is not visible. The only way to display the sheet is to add a new window (Window - New Window), choose the first "frozen" window (Window - 1. window) and quit this window. Then the new window is ready for use, but of course with the same limitations as the newly quitted one. Ring a bell, someone?? The funny thing is that in this workbook I also use the same functionality in another sheet without any problems.
I've built a macro to run a loop that opens excel files, prints certain sheets and closes them. I have the macro working - to some degree. here is my code (this is excel):
OldPath = "S:RMBS_Performance_Analytics Analysis1 Staging Folder For Monthly Model Templates2007200704VVDeals"
Dim t As Workbook
Dim s As String
Dim a As Window
.LookIn = OldPath
.SearchSubFolders = False
.Filename = "*.xls"
.MatchTextExactly = True
If .Execute() > 0 Then
For i = 1 To .FoundFiles.Count
s = .FoundFiles(i)
I have 2 problems. First problem is that I am trying to add a function to make the window close once its finished printing. This actually works - but it limits my loop iterations from i = 1 to 2 (so it only runs 2 times and I'm not exactly sure why). If I don't include the statement - this can run for up to 7 - 8 times (these are very large files) then excel runs out of memory. Unfortunately, i can't set the loop to run from i = anything other than one.
So What I would prefer is to be able to make the "ActiveWindow.close" command work - because this way I can run the entire loop. But I'm not sure how to. I tried window referencing, I tried adding a new active Window so when the file opens, its opening in the active window already, but nothing works.
Preferably, I need to be able to reference both windows, as my next macro will involve referencing 2 windows (one static - always open) and the other the loop above.
Floating Navigation Window
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.
Create A Popup Window
Is it possible to create a popup window that contains drawing objects?
I created a "form" with the objects, but I don't know how to use the form.
I want to have this image, or form, or whatever it is, to popup when the user clicks a cell. Is this possible without getting into programming?
Can it be hidden and then made visible when the cell is selected?
Open In A Simple Window
Is there a way that I can make an excel sheet and save it in a way that when it's opened the person JUST sees the cells in a really simple window...
Not sure if I'm confusing people in how I explain this... but basically I don't want it to show the scroll bars, the A B C D etc and 1 2 3 4 etc, the tool bars... etc. JUST the specified cells in a sheet.
Single Step Window
I do have code, but this thing (which appears on the Excel window, not the VBE window) doesn't seem to be connected to any of my code.
What is this, and what caused it to suddenly pop up on me in Excel?
Edit Window Not Working ..
Heres a strange thing, My latest version of a spreadsheet i have design has got a small problem. When clicking on a cell, nothing appears in the edit window, and when you double click on the cell to edit the contents the data disappears.
This only happens on one sheet within a workbook of 7 pages. The werid thing is that it does not happen on the version before
Any ideas how this could of happened and is there a fix?
Document Recovery Window
When I start Excel I get a Document Recovery Window that lists a file that was lost some time ago. I don't need the file and don't want the window appearing. If I click on the listed file, or right click and select "open", "save as", or "show repairs", the window disappears and I get a blank document.
I know I could write code that would automatically close the window when I start Excel, but there has to be a better way. I DO want the window to appear when there is really a file that needs to be recovered, but I don't want the listed file and don't want the window.
Activate Application Window
The bold line below does not work, Word remains the active window. The commented routine is a Chip Pearson API routine to do the same thing, it doesn't work either.
If infobox = vbOK Then
AppActivate "Microsoft Word"
print_dialog = wordapp.Application.Dialogs(wdDialogFilePrint).Show
If print_dialog = 0 Then
AppActivate "Microsoft Excel"
Activate Window Where Name Is In A Cell
I am trying to activate a window and the name of the window to be in a cell. lets say: Windows(file2.xls).Active
I want something like this: The name of the file is in B2 cell in tab Sheet1 in file file1.xls so the line will be like:
i do not know what function to use.
Close Browser Window
I'm relatively new to macro's. I have an excel workbook that draws information from an exported file from a website. When I do this I get an IE window open which is of variable name depending on the information I picked on the website. I am trying to create a macro that will close this new window on importing but leave the original website window where it is. The name is variable but has the same format e.g. "http://batch+report+info....." with the later address changing depending on the info selected. I tried using a an " If name.like" formula but am too new to macro's to know how to implement it.
Popup Window When You Load Excel To Say Something
I am very new to programming in excel, so bear with me. I need to have a window that pops up when you load excel. I need it to say something like
If A2 > A1, then the popup should say "value exceeded in row 1"
If B2 > B1, then the popup should say "value exceeded in row 2"
If both of the statements above are true, then I would like both of the errors to be in the same window/popup, instead of two seperate ones. I hope thats clear.
Open Window With Data From Other Sheet
Say im in sheet 1 at B2. Am looking to create a button so when I press it a small window opens and displays the data that is it sheet 2 (which is just 2 columns of a list of products and price.
Then I for example double click on a product and it will be added in the current cell.
How To (not) Save Workbook Window Position?
I have two wide screens, and I stretch excel over both of them to gain the most useable space. Sometimes I save a file while it's on the right screen. This causes problems for my boss, because she opens the file on her computer and it opens offscreen way to the right. I could have sworn there was a setting in excel to save or not save the workbook's window position, but now I can't find it.
Getting The Window Handle Of All The Open Workbooks
I am trying to get the caption that is displayed on each window of all the open workbooks. I am using the code below to loop through all the workbook windows, get their handles and finally display their respective captions on a Msgbox.
I am having 2 problems:
1- The code loops only once instead of once for each open workbook !
2- The Msgbox displays an empty string instead of the workbook caption !
If I am not mistaken, problem 2 is due to the fact that the Class name"EXCEL7" used in the code refers to a worksheet and not to a workbook. The trouble is I can't figure out what a Workbook Class name is so that I can use it in the FindWindowEx Function
Private Declare Function FindWindowEx Lib "user32" Alias "FindWindowExA" _
(ByVal hWnd1 As Long, ByVal hWnd2 As Long, ByVal lpsz1 As String, ByVal lpsz2 As String) As Long
Private Declare Function GetWindowText Lib "user32" Alias "GetWindowTextA" _
(ByVal hwnd As Long, ByVal lpString As String, ByVal cch As Long) As Long
Private Sub CommandButton1_Click()
**Dim BookNameLenghth As Long
**Dim strBuffer As String
**Dim bBufferSize As Long
**Dim lParent As Long
**Dim lChild As Long
Read IE Window Title And Store Value
I want to create a macro that will look at the IE windows that are currently open on my machine, check if the window title contains a certain word e.g. “Results” if so return the full title of the window and store in the worksheet.
I have been searching on the internet for quite some time for this with no real results which leads me to believe it might not be possible.
If it is possible I'm not asking for someone to write all the code for me (I realise how annoying that is!!) but if someone could point me in the right direction or even just tell the code that would return the title that would be great.
Set Window Size With VBA.
I'm looking for a way to use VBA to set the window size upon opening the workbook. When the document opens, there should be two windows, each taking up half the screen and each on a particular tab.
Currently, if I save the workbook with the window settings I want, when I open it, both windows are maximized. When I hit the restore button, they go back the settings with which they were saved, which is what I want it to look like as soon as it's opened. Also, a bonus would be for the code to determine the screen size, so it can fill the screen no matter what monitor/computer it's opened on.
Doubt In Macro Window In 2007
This is the first time i am using this forum. I am having a doubt in the macro. I am using MS-Office 2007 version. In Excel 2007 when you go to "developer" tab, the first group is "code" under that when you click on "Macro". You will be able to see a button called "create". Can you tell for what purpose it is used? when it will be "active" because it is always in disabled state.
Append Value To Url In IE Using Window Handle?
I'm trying to manipulate a URL in an already opened IE browser window. In a nutshell, I need to change "http://www.excelforum.com" to "http://www.excelforum.com/this-is-the-new-part"
The code prior to this does the following:
- Opens a new instance of IE
- Enters the username and password required to get into the site
- Scrapes the source code, imports it into Excel, and parses the data
- Finds a row based on the current date and some text
- Extracts from that row a unique identifier...
- Obtains the window handle ID for the instance of IE displaying the website
Now I need to add the unique identifier to the url. I cannot open it in a new tab or instance of the browser, as it revokes back to the login screen. I was assuming that the best way to do this would be to get the window handle, then just send a "tab" to get back to the URL, and enter the new URL. If there's any other way to do this, I'm all ears. Otherwise, how can I send the keys using the window handle?
Popup Window Appears With A Question
when opening Excel, a popup window appears with a question. you can then enter a value to answer the question in the popup window. then you can press enter, another window will popup with another question etc. the values you've entered will be inserted to the excel body appropriately. for example,
popup window with question: "What is your name?" your answer "John Doe"
popup window with question: "What is DOB?" your answer "1/1/2009"
the two values will be inserted as below: this is John Doe. My DOB is 1/1/2009.
Force UserForm To Always Be Top Window
Is it possible to create a "floating" UserForm with VBA? That is, a form that is always on top af all the other windows. If not I think I will have to create an application in VB that imports data from the active Excel Spreadsheet, wich I have been lead to understand is fully possible. I really need this for the application that I am currently developing and I from what I have heard it is possible in VB.
Select Previous Active Window
I have multiple excel workbooks open at the same time. I need to run a macro on one of them every 15 min but I need to return to the active window when the macro is done. How do I read what window is active then return to it when the macro is done?
dTime = Now + TimeValue("00:15:00")
Application .OnTime dTime, "AutoSave"
Application.DisplayAlerts = False
ActiveWorkbook. SaveAs Filename:="c:excel" & Format(Time, "hhmmss"), FileFormat:=xlCSV
Application.DisplayAlerts = True
Open New Window With Changing File Name
In VBA, how do open 2 new windows, and allow for the fact the file name will change (or name the new windows the current file name)? My current file name is "Metal.xls"
Here is what the code looks like now: