msg box

Hi all. I hope you can help I have a piece of code that is producing a run time error 91 I am trying to get a MsgBox to tell me if there is a sheet in my workbook called "In Progress" or else that is not in my workbook but it is creating an error on this line If worksheet.sheet.name = "In...

This is my first time posting on the forum, so I want to go ahead and thank you all for the support that you have given me so far. I am very new to VBA & Macros, so if my question seems silly, I apologize. I have tried researching this, but I cannot find an answer. Here is what I have: I am...

Hi, I've got a question regarding VBA coding and the message box functions. currently I've got a string of information (where the goal is not to have a message, all messages displayed are error messages). However if my string is empty/blank (so no errors) is there a way to say "no error...

so if there is a date that is defined in range a1 that is within 48hrs then the macro wont run? and offers a MsgBox instead? many thanks jamie

My input box fills the inboxfldr in this code Set Fldr = olNs.GetDefaultFolder(olFolderInbox).Folders(inboxfldr). If the object isn't found the vba gives a run time error. I want to suppress that error, prompt a message box that folder isn't found and just re-promt my inputbox. Looking for some...

Hi All, I have a sheet where employees submit weekly activity figures. They enter figures in section A and Section B where the totals are in Cell A25 and A60. At the end they then click a button (in a macro called "Submit")to submit the figures. What i want is a message or error box to pop up...

Hello. I have a userform that I use to introduce some data on Excel. Most of the data must be filled (that are textbox that the verifications dont need the information to do the calculations), because if they are not filled the rest of the Worksheet cant do the verifications that I need...

Good afternoon everyone. I need to put in a pop up box in my VBA code to have it ask the user if they want to do something. They can click Yes or No Yes: continues as normal No: skips a section of the code I did a few tries at this and keep getting an error. I know this is simple. Can...

I am trying to write code which changes the color of text added to a string through an input box. It works great if I only have to add colored text to the cell once, but when I try and add any more information through the input box it resets the color of all the text. What I want to do is keep...

Hi All, I am looking for a macro which will save out the DATA RANGE as a '.txt' file and for the filepath to be a msgbox pop-up for the user to browse and pick the correct folder to choose where the new '.txt' file should be saved. The new '.txt' filename can be "test". DATA RANGE: starts in...

I need too make a code too make the following dialog box.. could someone PLEASE give me the code? Excel Help Forum

Hi everyone out there in Excel help land. After a hard day trying and failing to get some-where with some VBA code I was hoping for some advice. My VBA coding ability is intermediate at best and in a previous life I used to get by simply walking across the office to troubleshoot with some...

i would like to show a message when the workbook is saving as i have a big document and it can take up to 30 seconds to save. i would like the message to be displayed until the process is complete. does any one have any ideas? Would be a big help Thanks tom

I need a pop up box in excel as follow Cell E3 has a text based on formula Cell C3 has a text based on formula Cell C4 has a text based on formula What I need When data inputted in cell B3 or B4 a pop up screen will appear with the value in of the three cells in three lines E3 C3 C4

Hello everyone,I'm still having issue with a previous post.I've made the changes to my Macro but I'm getting a invalid procedure or argument error when C9 = "OK to submit". The correct msg box appears when C9 reads "Fields left to complete"When I debugger it shows this line...I've checked it...

It's been awhile since I've done VBA so I'm rusty I have a sheet, that has an If statement saying =IF(B9>0,"Fields left to complete","OK to submit") there's also a Submit button. If user clicks submit button and cell says "OK to submit" then a msgbox comes up saying it will send an email to...

Hi all - thanks in advance for any help. I have an application which basically works fine, but I am looking at making some improvements. One thing it does is try to work with other files held on network servers. Occasionally, these files have already been opened by another user, and so the...

I am working on a time table worksheet and I need to insert a time Offset that can range from 5 minutes to an hour with 5 minute increments. The message box or user form will prompt, "How long is your Offset:" The problem is that I only know how to do make a drop down list that is populated...

Hello, I have attempted (rather unsuccessfully) to combine 2 separate codes and now I can't get the message box to appear. Anybody have an input to help me? Sub sales1()Dim Msg, Style, Title Rows("125:136").Hidden = Not Rows("125:136").Hidden If Range("K170").Value < Range("Info!E34") Then...

I want to launch a message box whenever a specific cell (h12) is equal to 1 (its other value is 0). However, this cell value is not typed in; it is enter using an IF statement (so using a formula). Any way to account for the change when the cell is value is not typed in or fool the macro into...