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
View Complete Thread with Replies
Sponsored Links:
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: Sub Export() '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 End Sub
View Replies!
View Related
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.
View Replies!
View Related
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.
View Replies!
View Related
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 tag.Click Exit For End If Next 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?
View Replies!
View Related
Calendar Pop Up On Specific Cell
I have search through this forum and gotten all info necessary to set up a calender pop up except for one piece. I am using excel 2003 with XP and would like to put got on a work sheet so if I select range K31:m37 my calendarfrm will show. I have seen code for it to work with a date formated field but I would prefer it work on a the range only.
View Replies!
View Related
Open A Specific Folder View Window
I'm using this code below sucessfully to open a specific folder view window. What i'm looking for is a way to amend it slightly so that when the window opens the 'folder tree' on the left hand side does not show, as it always does at the moment.
View Replies!
View Related
Error Message To Pop Up If Two Specific Cells
I am aware that you are able to create error messages in Excel by using the Data -> Validation tool, but this will not work in my case. I am wanting an error message to pop up if two specific cells' figures in my spreadsheet do not match up. The only way the Validation Error Message will work, though, is if figures are typed DIRECTLY into the cells. This is not the case for me - I have formulae in my cells. Apparently utilising a "VBA Macro" may work??
View Replies!
View Related
Assistance With Creating A Specific Macro Using VBA Code
I was wondering if someone could help me generate a Macro to do the following: I have a sheet with the following characteristics. Column A, rows 8-15 contain headers Column A, rows 17-24 contain headers Column A, rows 26-40 contain headers Column B to CV, row 6 may or may not contain an "X" Column B to CV, rows 8-15 & 17-24 & 26-40 may or may not contain the various data I need a macro which does the following on the press of a button located somewhere on the sheet: Generate a .TXT file in the folder C:Test with the name "Test_YYYY_MM_DD_HH_MM_SS_Full.txt" which uses the system time and date to fill in the values In the TXT file the following data should be created: ....
View Replies!
View Related
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.
View Replies!
View Related
Time In Specific Cell When A1 Contains Data
A vehicle has been assigned to collection, time of entry appears in Load cell coresponding with vehicle eg.e vehicle 1 'A1' = load 1 'B1'. I can get the exact time to appear in the cell currently but when I try to assign a second truck, the load 2 'B2' cell AND the load 1 'B1'. Im sure that there is an easy way to do this but i just cant figure it out. Can someone please help me out. Can i disable the cell that is updating?
View Replies!
View Related
How To Get Data From A Cell Given A Specific Criteria
I have a big data sheet. I have approximately 2170 rows and 50 columns. In some rows I have a series of consecutive zeros. I need to build a formula that gives me the date ( located in row3) right before the first zero in the series of consecutive 12 zeros. For instance in row 1340 I have a series of 12 consecutive zeros. The first zero happens in column AC, therefore I need the formula to retrieve cell AD3. however every rows has zeros located in different cells therefore I need a general formula.
View Replies!
View Related
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: Windows(.............).Active i do not know what function to use.
View Replies!
View Related
Return Data Infront Of Specific Letter In Cell
ColA contains Purchase Order (PO) numbers and I want to return the department number or project number (which is contained within the PO) in ColB eg. A B PO # Department/Project # AP001234P1234 Want to return everything before the 'P' PR004444P4444 Same as above TR2008-1234 No need to change 6501P1234 Want to return everything before the 'P' I was using IF function but there are too many variables then I thought about the 'P' but not sure how to go about it?
View Replies!
View Related
Copying Row To Other Worksheet If Cell Has Specific Data
I have an Excel 2003 spreadsheet with multiple sheets - one main one with all data and others which have only the data that falls into certain criteria. I'm wondering if there's a way to enter the information on the main sheet and have it automatically populate the correct "sub-worksheet" depending on what is entered in a specific column. I'm not describing this well but I've attached a sample of what I mean.
View Replies!
View Related
Formula To Search A Cell For Specific Data To Extract
I was wondering if there is a formula that will search a cell for a word or other specific criteria then if it finds it, puts the requested data / word in the formula cell Example: If I have a list of vehicle descriptions all in different formats: CAR1 1.4 SRI 3 door Hatch CAR2 5 door saloon GSI 2.0 V8 2.2 CDX 5 door CAR3 Estate CAR3 Estate 5 Door CDX Say I want to know which ones are CDX varient I need the formula to look in the cell and return "CDX" or "YES"
View Replies!
View Related
Macro To Capture Data From A Specific Cell Upon Selection Changes
I'm trying to do is definetly simple to a lot of you, but I'm struggling on how to get started. I attached a workbook that clearly shows my work! I'm almost there but not quiet. Basically the user will be able to make a slection that will be used to lookup values from a different sheet. Each selection triggers a ranking number at the bottom (red pattern) in the worksheet. Now I would like to capture all scenarios and display the ranking.
View Replies!
View Related
Minus Number From Cell And Result In Specific Cell And Specific Column
I have number in cell (A1) = 100. when I enter number in any cell of column(B) for example (B1)=10. then in cell (C1) the result of (A1) - (B1) = (90) and if I add in cell (B2)=10 then in cell (C1) the result of (A1) - (B1+B2) = 80 .accumulatively in cell (C1). and any number in column (B), the result will be (A1) minus any number in column(B) accumulated in (C1) second question I have number in cell (A1) = 100. when I enter number at cell (B1) = 10 then the result would be in the adjacent cell (C1) = (A1) - ( B1) = 90 and If I enter a new number in cell (B2) = 10 then the result would be in the adjacent cell (C2) = (A1) - (B1+B2) = 80 and If I enter a new number in cell (B3) = 10 then the result would be in the adjacent cell (C3) = (A1) - (B1+B2+B3) = 70 and so on. I want the result to be add automatically to adjacent cell in column (C)
View Replies!
View Related
Too Much Data Per Cell, Search/copy/paste Specific Values?
From mySQL database, i am getting a ton of data that is all being inputted into a single excel cell. Within this cell, there are certain data points that i wish to obtain (Bank #, SSN #, Routing #). There are multiple difficulties in obtaining this information. 1. these cells contain the same fields, but different number of total characters (differing in names, addresses, etc.) 2. some of the data points (like SSN) are inputted incorrectly, so even though a SSN is only 9 digits/characters, I may have to output all 11 that the SQL database placed within the cell. Can I get some help? I'm thinking of a search function/macro within excel, because all of the fields show up correctly. something like (i know this doesn't work) = or("cellA1" contains/finds/function SSN,return the 9 characters after "SSN ") um...yeah. difficult to explain, i'm sorry! edit: not sure what is wrong the file. I have attached a new one.
View Replies!
View Related
Pop Up Textbox In Data Validation In Protected Spreadsheet With Certain Constraints
This is the code where you click on a cell that has been input from Data Validation, it gets a pop up textbox showing the text input. One drawback I see here is that when the sheet is protected, one needs to tick 'Edit Objects' in 'Allow all users of this worksheet to:' window to get the textbox to pop-up otherwise no textbox is shown. So this leads to the accessed user to have the ability of deleting and moving the textbox in the protected spreadsheet. Do you have any idea to Protect the sheet, Get the textbox to pop up, Disallow user to delete/move the textbox.
View Replies!
View Related
Pop Up A Userform To Ask User To Key In Data Based On The Keyword
i am attach an sample excel file here. 1st sheet "sample", first, the marco look for column c "F No." if it search the content start with "F" and follow by 8 digit numberic, 2nd sheet "pop up", then pop up userform to ask user to key in the textbox there. if it search for as many as "F" with 8 digit numberic, it will show at the userform and ask user to key in the data in the textbox there.. 3rd sheet "key in", user can key in any data they want 4th sheet "output", after the user click the "OK" button all the data put in the textbox there can automatic go to the column "a" can refer by the sheet output..
View Replies!
View Related
Macro Create A Hyper Link Once Data Is Entered Into Specific Cell
Is it possible to have a macro create a hyper link once data is entered into specific cell, i have a multi sheet work book used as a stock card system. Each stock item has its own worksheet and the product code is entered in to cell E3 (which in turn has a macro in it to change the sheet name to match the product code). the macro also inserts a row of info into row 5 of another sheet used as a summary sheet ( CONTROL.SHEET or SHEET 4) using copy and paste link. i need a macro to generate a hyperlink in cell D4 of the control sheet between the row info and the matching product code sheet ( the product code is displayed in cell E4 of the control sheet. I only input one item at a time and then manually cut and insert the row info into the stock list on control sheet. so every time i input a new item, the row info is always in row 5 of the control sheet.
View Replies!
View Related
Pick Data From A Specific Row/column (eg 10/B) Related To Active Cell
I have a spreadsheet with my Periods along row 10. e.g. C10: "1", D10: "2", E10 "3", F10: "4", G10: "5" etc. (green on the attached sheet). I have my departments along column B, e.g. B11: "Baked" B12: "Fresh" B13: "Frozen" (yellow on the attached sheet) what I need and cannot work out is some VBA code that will populate two variables (lets call them Period & Department) when I click on one of the figures. For example if I click on cell: if I click E14: Period would have the contents of cell E10, and Department the contents of cell B14. if i click G14: Period would have the contents of G10, and Department the contents of cell B14 again. I know how to get the click on the cell to work properly etc, and I have code to slot these variables into that works very nicely, I just can't get this bit to work!!!!
View Replies!
View Related
Pop Up Reminder Listing Cell Then Go To It On Yes
Column B on worksheet3 has a list of dates on it. Column C states set reminder. Column D states how many days before reminder i.e. 3, 7, 10, 14. If the reminder is set to on. Can VBA code be run when the Workbook (or worksheet) that checks this criteria then a pops up is displayed outlining the event (say Cell A)? Also is it then possible to have on the pop up - Go to this event (i.e. row of data?)
View Replies!
View Related
Link Pop-up On Cell Select To Cell
I'm hoping to hover my mouse over a cell to display text as popup. This text is linked to a cell and is dynamic. I'm only wanting this feature to display info (in the popup) not link to a website Currently I've dodged my way around the issue by using a hyperlink for the sole purpose of taking advantage of its hover popup feature. The problem is that a hyperlink popup is limited to 255 characters so i can't display much text. Is there is any VBA code or add-in's that take advantage of the mouse cursor position to display a text popup? Kind of like the Comment feature but for dynamic use.
View Replies!
View Related
Macro To Find Required Data Than Copy/paste In Specific Cell Address
I want to copy some data from internet and paste it in to worksheet location Range A1:A30. the data look like following information. LocationKuwaitP.O.Box:4819 SafatAddress:ShuwaikhTel:-22253580Fax:-24343645Category:CONSTRUCTION COMPANIES the above information have following header ie. Location, P.O.Box, Address, Tel, Fax and Category. every time one of the header inforamtion is missing ie. Address or P.O.Box, Or Fax, due to this problem every time cell address of information aganist header is change. supose in first copy/paste Tel inforamtion is in A15, but second time it may be on A13, and 3rd time it may be on A17 and so on. I want to make a macro which search header ("Location", "P.O.Box", "Address", "Tel", "Fax", "Category" ) from a Range A1:A30. than down two steps to copy header information (75325412) and paste in fixed cell location C1:C5 (C1=Name, C2=Location, C3: P.O.Box, C4=Address, C5=Tel, C6=Fax, C7=Category) in same sheet. and repeat the steps to copy information aganist header from all header in Range A1:A30.
View Replies!
View Related
Expression For Pop-up Message Based On Cell Value
I have been reading the different post here on the forum. I have found a snippet of code that will open a pop-up message from a value of a cell. I would llike to do this on one of my reports. Here is the scenario. Range (R5:S5) 0.15 them MsgBox "Note Must Be Entered For +/- 15% change" But There are 14 different cells that I want this to work for. The value differs from day to day, and this should pop-up happen without a user having any actions other then the calculated value. But ones the note is entered in the "Notes: cell the message will not return. Hope I explained it correctly. The value of the cells in question are calculated in each cell with a formula example "=IF(ISERROR(Z20/H5),0,IF(ISERROR(Z20/H23),0,(Z20/H23)))"
View Replies!
View Related
Click On Cell Makes Calendar Pop Up
I have read through numerous posts, but cannot get one thing to work. I am using Excel 2003, and am trying to get a calendar to pop up, to select a date, and then return that date to Cell B2. I was successful at making the calendar pop up by the following methods: 1. Added a button to the toolbar, and assigned the Calendar Macro to it. 2. Using VB, added a sub-menu item to the right-click (context) menu, using the code below. Private Sub Workbook_Open() Application.OnKey "+^{C}", "Module1.Macro2" End Sub However, my goal is to make the calendar appear when I click on cell B2. I tried using the following code, but when I click on B2 nothing happens. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$B$2" Then UserForm1.Show End Sub I also tried: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean) With Worksheets(ActiveCell.Worksheet.Name) If ActiveCell.Column = 2 Then If ActiveCell.Row = 1 Then UserForm1.Show End If End If End With End Sub
View Replies!
View Related
Pop-up Message For Cell Selection Or Mouse Over
I was just wondering if it was possible to get a collapsible menu/dialog box for excel when a user clicks on the cell of interest. I don't want to use the collapsible list function as I would rather the user be able to click on the cell of interest and then have that cell produce maybe another window/dialog box which will show the user what I have put in there - maybe a chart or table or just a set of data - and perhaps allow them to cut and paste the data as well? However, most importantly, I just want a dialog/window box to appear rather than having to group and use the collapsible list function. I've attached an image of what I have in mind.
View Replies!
View Related
Force Focus Back: Pop Up A Userform To Provide Instructions And Collect Some Additional Data From The User
I'm working on a spreadhseet which has several macros that can take up to 5 minutes to run. When the macro(s) complete, I pop up a userform to provide instructions and collect some additional data from the user. The "problem" is that when the user moves to another application to do other work, the user form remains hidden behind the active app. I've added some text to the status bar to let the users know the processing is done, but they would like something more obvious - so, is there any way I can force focus back to Excel?
View Replies!
View Related
Specific Cell To Run A Specific Formula
let say in cell A6 i have a list SnG Cash MTT I can pick one of these. If i pick Cash then i want a specific cell to run a specific formula. depending on the item chosen. So in cell A6 is the list. in cell B6 an amount will be place and in C6 another amount will be place. the number for c6 will range from a -number to a +number. But D6 looks to see if B6 meet the requirements for MTT, SnG or Cash depending on which item was selected from the list. and uses the formula below with $c$3 changing from to either $D$3 or $F$3 and comparing the values for the chosen item. the formula changes would look this =IF(ISBLANK(C6),IF(B6>$C$3,"Do Not Play","PLAY"),IF(C6<B6, "Lost","Win")) =IF(ISBLANK(C6),IF(B6>$D$3,"Do Not Play","PLAY"),IF(C6<B6, "Lost","Win")) =IF(ISBLANK(C6),IF(B6>$F$3,"Do Not Play","PLAY"),IF(C6<B6, "Lost","Win"))
View Replies!
View Related
Creating A Data Form With Data Validation
I have limited ability with Excel, and I'm trying to create a database using the Data/Form menu choices. My problem is I only want specific data in two of the 20 or so fields. When I use Data/ Validation and direct data entry, I get exactly what I want, EXCEPT that the choices don't come up when I use the Data/Form. Users can enter anything they want, which defeats the purpose. I tried to build a user form to use for data entry, but I don't know how to get it to add items to a database or lookup items like the data/form process does. I also want to add a few macro buttons to the form to do other things. I am pretty sure of a few things: 1) This should be pretty simple. Anyone knowing VBA would probably know how to do this in minutes. I found some code that did a simliar function, but couldn't interpret it to fit my needs, which brings me to 2) I'll never use VBA or complicated macros again. I don't have the need for them. This is just an isolated incident. Therefore, signing up for a class would be useless to me. I tried to locate some advanced Excel/VBA classes, hoping to find an instructor or even a student who would welcome a simple challenge, but there are none available.
View Replies!
View Related
|
TRACKER
