popup

Hi, I am new to the VBA and don't have any knowledge. I have an requirement where in i need to reset the defaults for the user. I am currently able to login to website, navigate to website and able to click on the link. Upon clicking the link, a popup window appear and i need to uncheck the...

I have a macro that opens a shared workbook, renames it and saves it again in a different folder, then creates the file again in the original location for that day's work. This macro is run by different team members each day, and none of them are tech-savvy. This has been running very well for...

Trying to have 3 different userforms popup based on the document having three different names- basically I want a userform to popup when the document is the "template" then once it gets saved as "working" for the first time, a different userform will popup, then as it gets saved as again...

Hello, hope that someone could help What I want to do is that use an Excel formula to trigger a popup if the value entered in a particular column is a duplicate unless if the duplicate value is a "-" or a blank cell. The function would be able to run for the whole column. For example below...

My spreadsheet is getting too cluttered with buttons, menus, text boxes, etc. Is it possible to create a custom popup menu that contains multiple form/ActiveX controls and appears when the user clicks a button on the spreadsheet? I found this basic tutorial here...

Hi, I am a beginner with VBA codes, and I am working with the script below. Basically I have the D17:D36 range set as "No" responses. If a user selects "Yes" for more than one of the cells, then I want the message box to show up. The message box is working as it shows up, but I have to click...

I use a template to create different spreadsheets with different information but use 1 macro to sort this information and do various things. One thing i have not figured out how to do at the end of my macro is to have the Header/footer option popup. The header always has a different name so. How...

Hi Team, I am using the following code to save a file with a new name Private Sub CommandButton1_Click() CommandButton1.BackColor = 5950882 ActiveWorkbook.SaveAs (Range("d4").Value & ".xlsm") End Sub When there is no existing file with the same name, the file is saved as desired. When...

I need some assistance. The following code is not working for me, as it does not create the popup. Sub FindColor() Range("D4:P1004").Select If ActiveCell.Interior.Color = 255 Then MsgBox ("Leave a Comment") End If End Sub

I want a popup message to appear when a box is checked, but I don't want the message to appear again when that same check box is clicked again to uncheck it. I'm currently running this code: Sub CheckBox582_Click() rsp = MsgBox("Please provide reason for rejection via email or in the...

I have few hundred data (product ID) and I have graphs for each of the data. I saved these graphs as png in a designated folder. The filename for the graph is "productID1 - productID2" because I wish to compare the data for 2 products. I wish to use VBA code to popup the image when I click on...

I have a button that users can click which will open the SaveAs popup box, where the user can input a file name to save as. What I need it to also do is to go to a particular folder to save into. The folder (called "Cost") is in the same folder as the excel spreadsheet, but need to keep them...

Hi all!! I need to return in a Macro the selected caption of a PopUpMenu... In a Module: Option Explicit Public Const Mname As String = "MyPopUpMenu" Sub DeletePopUpMenu() ' Delete the popup menu if it already exists. On Error Resume Next Application.CommandBars(Mname).Delete...

I am looking for code that will generate index numbers for ALL CommanBars I have been searching all over the place and can't seem to find it. Reason being is I'd like to use a number rather than hardcode >> "Cell" or "List Range Popup" for an example Dim Bar as CommandBar Set Bar =...

Today I somehow manged to get a popup window to open that appears to format a particular chart. I have no idea how I opened it, nor how I can get it closed. It stays up on top of everything and anything...different sheets, different menus etc. Can someone tell me A) how did I cause this...

I can pass one variable ok, but I need to pass 2. Doesn't seem to work.. Is there an example with 2 variables? Public Property Let iItem (aa As String, v As Integer) ... do stuff End Property Dim Test as Popup Set Test = New Popup Test.iItem = "Fred", 9 ("Fred", 9) in brackets nogo either.

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:RelyOnVML/> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hello, Thanks to all for the knowledge you like to share. Well, in fact I’ve already created my pop up calendar a while ago using vba and the dtpicker +...

Hi Guys, I am trying to put a data picker (calendar popup) in a column in a table (table[column]) that will popup whenever the cell/field is selected. All the solution that I googled and found refer to a range. The problem is that I not very good in VBA and i want to limit the popup only to the...

Dear Masters, I have one VBA on Excel that send email to Outlook. Sometimes on Outlook a popup message open. I'd like a VBA on excel that check if Outlook has a Popup click OK if not go ahead. Thanks

Hai, How to add comments on powerbi report, example click the amount add popup the note for explanation. tq