popup

Hey I have a excelsheet that several ppl use. In it i have built a userform that ppl use to input data, read and edit data. One action the users do is to mark data s "completed". In my table the row gets an TEXT in one column, stating that that row is "done". I would like to build some kind...

I am looking to have a popup display a value in a specified cell. Thanks in advance!

I am trying to get a msgbox to popup based on a value in the spreadsheet. I am currently using the below but whenever I open up a second workbook, im getting a Microsoft Visual Basic Run-time error '9': Subscript out of range Private Sub Worksheet_Calculate() If Sheets("Fx").Range("F1").Value...

Hi all, Thanks in advance for any help that you can provide. I haven't used VBA in years, but I'd like to get back into it and I'm having some trouble. Here is the scenerio: I have a product description and a range of values as percentage in cells H12:K12. I need to have a pop-up message with...

Hi! I would like to write a macro that shows all cells address (or row) which value is 0 in column 10. So far i only could manage this: Sub check() Dim LastRow As Long LastRow = Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To LastRow If Cells(i, 10).Value = 0 Then MsgBox ("0...

Hi, I have one workbook with several worksheets, however when i run it, it only run on one worksheet. Can anyone help me to make this code also run for other worksheets in the same workbook? Here is the code: Private Sub Workbook_Open() Dim LRow As Long Dim LName As String Dim...

I have a bit of code that will work when launching via the ribbon (or from VB), but not will not work when launched via a shortcut key. The activate tab box will pop up when launched via the shortcut key, but it won't go to the tab selected. This is for the box that pops up when there are more...

Hi I am relatively new to using the VB language and I’ve run into a slight hurdle. I’ve searched this site and others for a solution but I can’t find an answer that works. I am using VBA to login to a private (work) intranet page and then process data within the page. I can’t edit the page...

Hello again, I seem to be hitting another wall in my excel project. I have a box I have created in Excel 2013 when I click on the command button to input information on a specific sheet. The code reads as follows: First code is for the OK button. Second code is for the input boxes to go to the...

Hi all, Had a search for this but couldn't find anything.... hopefully someone can help! Basically I'm designing a user form and want the date picker to 'pop up' / appear when the user clicks in the text box and disappear when they click out of it. The input to the calendar currently populates...

Hello all, I am new to the world of Excel possibilities. I have a situation. I need to create an excel with about 100 columns, and 2 /3 rows. Column names are "Product Name", "Total Stock", and "Safety Stock". The inventory manager updates the excel each time a product goes out of the...

I am in need of a macro or VBA code that when ran will pop up a box and allow the user of the sheet to enter a name for example and the macro would search for the name entered and when it finds that name it will copy the entire row and paste it to a specific sheet. However I don't know if its...

Hi all, I need to create a pop up message for a whole column/ or A1 : A 60. if the value in B1 is greater than or equal to 100 I am new to VBA in excel

I have a script. One of the lines of the script current reads InsertLogo "c:\poet\ebp.jpg" This passes the name of a graphic to a sub that inserts that graphic into a spreadsheet. What I want to do is popup a form with two radioboxes. The selection of the radioboxes controls which graphic...

Hello everyone. I'll start with the credits; there's a really useful calendar code here: VBA Express : Excel - Userform Calendar Control Everything works fine, this part right here triggers it whenever I touch a cell with that format: Private Sub Worksheet_SelectionChange(ByVal Target As...

Good Morning, I would appreciate help with the following as I've been stuck on it for days and can't seem to work it out. Google hasn't helped much either! I've managed to set up a live auto-clock which displays live time as per my system time, to the second, using the following code in Sheet1...

Hi, I was interested in creating a spreadsheet that would drastically save my time. Essentially this is what I have: I have a table in one of the tabs called Time. The other tab is called Output. Basically, I have track my every day time in the table from the time tab and in every row I...

I've recorded a small macro that opens a text file, copies a specified range of values, closes the file, and finally pastes the values in my excel spread sheet... problem I'm running into is when the macro goes to close the file, a pop up window comes up that asks if I want to keep all of the...

Hi guys, I'm making a plan which includes some dates First row: Last date of inspection ( manual editing ) Second row: Next date of inspection ( adds 28 days to the first row ) Third row: days until next inspection ( second row min the date of today ) I want excel to give a popup message when...

Goal: I want to use Excel to automate the export of data from our SharePoint site back into Excel. I'm unable to create a workflow to push this from SharePoint, so I want to pull it from Excel. Where I'm stuck: When the export begins, a pop-up comes up asking "Open", "Save", or "Cancel". After...