Is there a way to use MsgBox without any necessary user interaction to continue on with the macro? For example, I want to occasionally display a MsgBox for a few seconds containing relevant data and then have it disappear and the macro continue on without the user having to click the OK button, etc.
View 3 Replies
I have created a multi utility user form that user can initialize by a shortcut key. The problem if user want to see the content on sheet or want to change the active cell, he has to close the form and then do any action. This form is initialized by a command and default included in excel as a Add-in. Is there is any way to make the form floating i.e. user can manipulate the data and can see the form as well.
View 4 Replies View RelatedI have a situation where I have an msg box pop up that asks the user to identify whether or not the file they have chosen meets the standards needed to continue running the macro. Specifically, I need them to answer "Yes" if the file has a list of data in the first column, if there are no blanks in that list and if the first row of data begins on Row 4. If they answer yes, the macro continues ahead and does what it needs to. If the person selects "no," another input box pops up that asks the user to make the edits. This msg box asks the user to click "ok" when they have made those edits. I want the macro to pause after the person has selected "no" from the first msg box, so that the person can make those corrections. Then, I want the macro to resume when the user selects "OK" on the second msg box. How might I do this? I have included the piece of my code below.
strresponse2 = MsgBox("Please confirm that the file you have selected meets the following standards:" & vbNewLine & "1. The information in the first column of this file is all of the job titles or job codes associated with this profile." & vbNewLine & "2. From the first job code or title to the last, there are no blank rows in this first column of data." & vbNewLine & "3. The first job title or code appears on Row 4, Column 1." & vbNewLine & "If the file you selected meets these standards, select Yes. If the file you selected does not meet these requirements, select No.", vbYesNo, "Yes/No")
If strresponse = 6 Then
Call getjobtitle
End If
If strresponse = 7 Then
'pause macro
strresponse2 = MsgBox("Please make the necessary edits to this file. When you are done, select OK to continue generating your job profile.", vbOKOnly, "OK")
If strresponse = 0 Then
'resume macro
Call getjobtitle
End If
End If
I was told that the following code would enable my macro to execute every time the user interacts with anything Excel:
Code:
' Repeatedly check for user interaction whenever a change is detected
Private Sub Worksheet_Change(ByVal Target As Range)
Call TestMacro
End Sub
It doesn't work...
To put it into context, he is my entire program:
Code:
Sub TestMacro()'
' TestMacro Macro
'
' Create string variable
Dim undoText As String
' Assign the text to string variable
[Code] ......
My being new to VBA doesn't work in the situation as my programming instincts tell me to set up an infinite loop to continually check for interaction something like the following:
Code:
while( x == 1 )
{
do MY_CODE;
if( USER_CLOSES_EXCEL )
x == 0;
} // end while
However, Excel is apparently 'Event Driven' so I'd love to know how to use this to my advantage in keeping my macro running.
I have a cell (B1) in the second Sheet. It contains two sentences of text, which will be spoken when entering that Sheet (by a click in the previous Sheet).
Code:
Sub ButStart_Click()
Sheets(2).Select
Range("B1").Speak
End Sub
When the Speak command is running no other user interaction can be made. As the text is quite long not all the users want to wait until it is finished. So I need the users to be able to click on the "Next" button which takes them to the next Sheet (and start speaking the text there).
I have a large file that takes a long time to close.
I would like to display a message that says " SAVING - PLEASE WAIT".
But I do NOT want any interaction from the user to continue so I can not use a MSGBOX.
How can I do this?
I want a MsgBox to pop-up to the user with 3 Options.
Option A, Option B, Cancel.
If user presses Option A GOTO 1:
If user Pressed Option B GOTO 2:
And if Cancel End Sub, not sure if this is doable, please let me know. Basically I am writing this VBA to archive files from the network drive and there are two different kinds and depending on what Option the user chooses, the Destination variable needs to take on a different value, that's why I need this, unless there is a better way to do this.
Basically so far my code is like this:
Sub Archive_GTP()
Dim Nlog As Worksheet
Dim DestinationFile, SourceFile
Dim lr As Long
Dim c As Range
Set Nlog = Worksheets("Log")..........................
I have a macro with about 20 Subs and before each one I wanted a msgbox saying "macro is now running sub 1." which then changes to "Macro is now running sub 2", all while the user is sat there with his feet on the desk twiddling his thumbs.
Is it possible to have a MsgBox that would say "Hello" to the user who is logged in on that computer. How would you reference the user info?
View 4 Replies View RelatedI have searched the 'net and read MSDN msgbox but I cant find what I am looking for. Maybe msgbox is not the correct function to be focusing on?? I want a message box to ask a question, and the answer is dumped into a variable, much like you can do with yes/no/cancel, but (much like a pop-up textbox) I want to be able to respond with text in a textbox. [This of course is part of my Excel spreadsheet]
(I think with C++ it was something like "msgbox = ?$-" or something like that, but I don't know what to look for with VB.)
I would like to be able to turn the following worksheet in to an inspection scheduler. It already displays job information pertaining to the job & lot number entered into cells C2 & C3 in cells F2:F14. Now, I would like to write a script that will do the following...
If lets say I click on "Groundwork", it will know that I am trying to schedule a groundwork inspection for the permit number in cell F11, and it will know it needs to be scheduled through Fairfax County's website, because it says "FFX" in cell F2. (the only two counties I really deal with online are Loudoun & Fairfax...I'm not worried about the others). So it will then automatically jump to Fairfax County's website (links to the websites are in cells E22:E26), conduct the appropriate steps to schedule an inspection through that county, then kick back some sort of confirmation that it was scheduled. The same steps apply each time for each inspection type, but each county has their own steps....
I want to write a piece of code to go to some webpage(URL in some excel cell) and then copy all the text on the page and paste to some other cell in the same worksheet.
I know I can open IE using VBA(Excel 2003),but is it possible to get everything on the IE window into the clipboard and then paste into any of the excel cells?
While running one of my application, excel will be opened at the middle. I need to minimize the excel and stop interacting with it, which means even if I click the excel task bar it should not open excel. It should be always in minimized state.
I have an code which works in XP and is not working in Windows7.
Code Snippet: ( which works in XP )
ExcelObject.WindowState = xlMinimized
ExcelObject.Interactive = False
I have an excel file with multiple sheets. I want my HR team to update that file, but one user shouldnt see the entries of other users. I want to make a consolidated file out of three files. This excel template is for salary input.
View 3 Replies View RelatedI have a user form that has a combo box "City" two text boxes one called "Flight" and the other "Date". What I'm trying to do is to prevent the user from saving the data input from the user form if any of those three fields is left blank. The code that I have so far checks all of the required fields, if any are left blank a message notifys which field(s) is left blank and return the focus back to that field. But the rest of code also fires.
What I really need is either to stop the code if any fields are blank and return the focus back to the blank field, the user completes the field(s) and clicks the save again, or better yet, pause the code until all the required fields are completed and then complete the save. (There is actually another 200+ lines of code in this sub, but I deleted it to keep the post a little shorter.)
find attached zip file . if you open the file then you can understand the problem.
I need to change cells color and text color as per user choice in Password protected sheet : (user is useing excl2000)
Kindly open attahced file i putted the note inside the file.
I am trying to check a user input to see if the user has entered the date correctly. I am using the code below but it keeps giving me a "Type Mismatch" error.
View 2 Replies View RelatedAn Excel file named CLEARING is availble in thr central server system. it will be accessed by 5 or 6 staffs from some other systems what i need is when one person accesses/edits this file the others should not even able to open in the read only file ,when the file is saved and closed ,then only the next person should access it
View 1 Replies View RelatedI have a workbook that is used to track overtime hours worked through the year. I've received some help from users on this forum, and others, to create the necessary macros and formulas to allow a supervisor to make use of the form; however, the workbook is also used to track those that wish to volunteer to work overtime each weekend. The sheet has a list of names for the employees on each shift, then a column to allow a "Y" to be placed under the date - designating them as a volunteer for any overtime available. I've found this spreadsheet (attached - from this site) that will allow individual users to access the workbook and have unique passwords for each. I don't completely understand how it works, but I feel it may be a start to getting what I want.
Essentially, once the user selects their name and inputs their password, I'd like the workbook to be opened and then allow them to only manipulate the row associated with their name. That row will change from week to week, so specific numbers will not be able to be used, but their name will be the same as the name used in the logon.
I feel like I'm asking for a lot here, so just some initial guidance on whether this type of thing is possible would be an acceptable answer.
i have been trying to add msgbox to show that if textbox1 and textbox3 are empty than show "please enter i.d or lockern no but if textbox3 is true than run the code or textbox1 is true than run the code.
View 1 Replies View RelatedI am currently setting up a ID/Password function on my spreadsheet. On the main page is the login boxes and an Ok button. When the Ok button is pressed, I have a formula that checks the user ID and Password and if correct, it types correct. Otherwise it types incorrect. This is using;
View 2 Replies View RelatedIn one of my spreadsheets users can see the active period on multiple worksheets
All have cell references to the 1st worksheet (cell B5). I would like 2 things:
1. If users change one of the reference cells on the other worksheets I would like a msgbox to appear
2. After clicking the msgbox away I would like the "old" cell contents (the referenece) to be restored.
I want to change this so there is a MsgBox vbYesNo button below where it tells you what cells are found & says:
"Is this what your searching for?" If yes Box closes. If No Continues Search.
How would I go about adding it to the code below?
If range K1:K1000 has "Yes" in there, to display a msgbox
But if there is 300 Yes's, how do i get it to do just one msg box and not 300
I would like it on a sheet Worksheet_Deactivate
* note K1:K1000 are drop downs with "Yes" "No" "Potentially" options
Hi, Please could someone help with the following code. I have 2 sheets 'sheet 1' and 'sheet 2'(hidden). Sheet 1 has a control button that takes you straight to sheet 2, however what I wish to achieve is that before sheet 2 is visible a message box appears if a condition is not met. Something like, if sheet 1 R29 is less than 5000 then msg box appears (I would need about 4 lines in the msg box), if ok'd then sheet 2 appears. If the condition is met i.e sheet 1 R29 = or is greater than 5000 then the msg box does not appear and takes the user to sheet 2.
View 8 Replies View RelatedIs it possible to modify and code not to have the OK button. I need to to be information process only. I have a long macro i need to user to be aware where in the macro run we are. I wanted to use this code... but i do not want to click the OK button i need it to just show that that step is completed etc...
MsgBox "October Finished", vbInformation
I am trying to have a msgbox come up if there is a path found it will pop up a msgbox for a few seconds then go away. Im trying to avoid the user from having to select anything just simpley telling them the connection is there then go away on its on. The code below is what Im currently using.
Code:
If Dir("H:") = "" Then
MsgBox "Error: Drive, path or file not found"
Else
MsgBox "OK: Drive, path or file found"
End If
I would like to add a MsgBox letting the user know how many days are left before the Trial Period is up.
Code:
Private Sub Workbook_Open()
Dim StartTime#, CurrentTime#
'*****************************************
'SET YOUR OWN TRIAL PERIOD BELOW
'Integers (1, 2, 3,...etc) = number of days use
'1/24 = 1Hr, 1/48 = 30Mins, 1/144 = 10Mins use
Const TrialPeriod# = 5 '< 5 days trial
'set your own obscure path and file-name
[Code] ..........
I was thinking of:
Code:
MsgBox "You have X number of days until you Trial Period expires."
But, I don't know how to code the part in Red to register a Count Down from the first day opened to the next.
It may be opened more then once per day. I just nedd a message on day 2nd - 4th day.
If opened on the 5th day, the rest of the code executes, closing the Workbook.
I have several material takeoff sheets and one material SummarySheet in my workbook.
Each material takeoff sheet has a subtotal cell at the bottom of the sheet. The subtotals are added together and the total sum is displayed in a cell on the SummarySheet. At least that is how it is supposed to work. Excel or somebody else arbitrarily changed the cell reference in the SummarySheet formula to call up the cell one row above the subtotal cell on the material takeoff sheets. This little action resulted in a loss of $674,000 and may eventually result in my unemployment. Meanwhile I am sitting here putting out fires.
This is what I would like to do: Place a formula on the SummarySheet or add a Macro that will trigger a warning message box if the total on the SummarySheet is not equal to the sum of the subtotals on the material takeoff sheets. Also would like to have the message box animated or brightly colored.
If(PlateCostsTotals+AppurtenancesCostsTotals+StructuralCostsTotals+MiscellaneousCostsTotalsSummaryCostsTotal MsgBox “Hey, Don’t You Know How to Add”) or an alternate formula that works.
I've created a routine that starts with a message box saying the following:
"Please Confirm 'DTmacTest.xls' is the ONLY open Excel workbook"
So I have an "OK" button and a "Cancel" button.
but no matter which one I press, it runs the routine.
How do I assign the cancel button to stop the routine when it's pressed?
