Message Boxes Not Working
Jan 25, 2007
This used to run correctly at the end of a macro. But, it doesn't now. I haven't used it in about 4 months.
Error is "Variable not defined." and highlights the 'Msg=' in the debugger.
Msg = " WSPrepSuper is finished! "
Msg = Msg & vbNewLine & vbNewLine
Msg = Msg & "The customers have been broken out, to their appropriate tabs."
Msg = Msg & vbNewLine & vbNewLine
Msg = Msg & " This should Save and Share, automatically. "
Msg = Msg & vbNewLine & vbNewLine
Msg = Msg & " Everything should be ready to go. "
Title = "WSPrepSUPER Macro"
Msg = MsgBox(Msg, 64, Title)
Msg = "Oh, yeah. Have a Nice Day."
' Msg = Msg & vbNewLine & vbNewLine
Title = " "
Msg = MsgBox(Msg, 0, Title)
View 9 Replies
ADVERTISEMENT
Apr 2, 2014
I am close to finishing making up an Excel tool that takes data input from the user, does some analysis, accepts further input then prepares a report. My coding skills are not what you would call high level, so my code could probably be more efficient, but it works (well, except for this issue).
The tool opens a main multipage userform for data entry, then allows the user to view the data in the spreadsheet tables with the ability to call separate userforms to modify, delete or add records. The user then calls another userform to do some calculations and enter the appropriate results from a separate piece of software, then presses a button to prepare a report. All userforms are called from buttons in a separate userform (I'm not proficient enough and haven't had enough time to create a new ribbon in excel). At various times, messageboxes are used to convey information or prompt the user to do something - these are all simple ones with either only OK button, or OK and cancel buttons.
My problem is that when userforms are called, they sometimes appear but are totally blank (white) - see image.
blank_form.jpg
Clicking anywhere on the screen or pressing any key will bring them up properly and they seem to function normally thereafter.
In addition, the messageboxes sometimes do not appear - pressing any key will make them do so. Other than this they function normally.
The frustrating thing is that these problems occur inconsistently. I can add or change some code and it stops happening, then after testing (entering data and using the tool) starts happening again. Sometimes it just stops happening with no apparent reason, but starts again later after fixing some code or just entering some data. Not all userforms are affected at any one time and not all messageboxes have the problem at any one time.
The problem seems to occur in those subroutines where I access or manipulate data from other sheets before showing the userform or message box (but in most instances, I need to do this manipulation in order to present the correct information in the userform).
Some thought processes I have had, and unsuccessfully tried to fix the problem with (some coming from various web forums):
I thought I may have done "Application.ScreenUpdating = False" without resetting it to true, so I commented out all the "Application.ScreenUpdating = False" statements - problem stopped for a bit then started again.
Some of the userforms were modal, and even though they were not showing were still loaded so thought that this may be impacting on other userforms/message boxes, so changed all userforms to non modal - still had the problem when I opened the tool again.
Tried using "RePaint" and "DoEvents" at various points in the code after opening a userform or message box - no change.
I have tried exporting a form and its code, removing from the tool, then re-importing it. No success.
Tried the tool on another computer and the same problem occurred.
View 10 Replies
View Related
May 22, 2014
I have a form with the following code:
[Code] ......
My problem is that no matter which option button is selected, all I get is the results for Case 2 and then the vlookup doesn't work. So if the user wants to cancel and reenter a new clock number they have to close the form and manually reopen it.
This was working until I decided I wanted a vbOKCancel instead of a VbOkOnly. However the uploader is not working for me.
The best I can do is a link for OneDrive [URL] ......
View 2 Replies
View Related
Sep 29, 2012
I am trying to suppress the error message (green triangle top left corner of cell). I have tried
Code:
On Error Resume Next
On Error GoTo 0
At the start and end of code, but to no avail.
Code:
Sub mcrpasteformulaandcommentlist()
On Error Resume Next
On Error GoTo 0
ActiveWindow.SmallScroll Down:=23
Range("C50").Select
ActiveCell.FormulaR1C1 = _
[code]....
View 5 Replies
View Related
Mar 5, 2014
I have a access table with two fields named as "Month" and "Bank Holidays". I have put names of the month in this table for 2014 and the corresponding bank holidays of each month. Now I want to write down the piece of code that will execute when a button on the userform is pressed and it should check the current month of the year and then display the total working days ( After subtracting bank holidays of that month and weekends of that month from the total working days of that month).
View 3 Replies
View Related
Apr 25, 2014
Because countif cannot be used across multiple tabs, I'm using the following workaround where "MySheets" is the range of tabs and E8 is the cell I want "counted".
=SUMPRODUCT(COUNTIF(INDIRECT("'"&MySheets&"'!E8"),"Fully implemented"))
This works perfectly, except that I really need COUNTIFS... I want Excel to count either "Fully implemented" or "Partially implemented" when in E8. I cannot get the formula to work and keep getting an error message.
=SUMPRODUCT(COUNTIFS(INDIRECT("'"&MySheets&"'!E8"),"Fully implemented",(INDIRECT("'"&MySheets&"'!E8"),"Partially implemented")))
View 1 Replies
View Related
Jul 26, 2006
I am developing a spreadsheet with numerous information on our different suppliers offices in the country for each of our outlets. I am tryin to define a way to do the following:
If a colleague selects a company another list will appear with the region and when the region is selected a list of the offices will appear.
View 3 Replies
View Related
Jul 11, 2009
How do you add icons into a message box. ie a warning triangle etc.
View 3 Replies
View Related
Jan 25, 2010
I have a workbook in excel 2003 which I had been running the following macros (listed below). We recently upgraded to Excel 07, and neither are working. When I try to run them, the "debug" option highlights the following line in the sort macro "Range("A2:z" & lastcell).Sort key1:=.Columns(1)". This is driving me crazy, as the macros worked perfectly under the older version of Microsoft. Is there an issue with crossfunctionality between '03 and '07'.
Private Sub Worksheet_change(ByVal target As Excel.Range)
If target.Column = 1 Then
ThisRow = target.Row
startRow = 1
i = 1
Set ws = ActiveSheet
maxRow = Cells.SpecialCells(xlLastCell).Row
maxCol = Cells.SpecialCells(xlLastCell).Column
ActiveSheet.UsedRange.Interior.ColorIndex = xlNone
Do While i
View 9 Replies
View Related
Feb 1, 2007
I would like to create a combo box however the contents of the combo box depends on what i have selected in a previous combo box.
View 2 Replies
View Related
Jul 28, 2006
I have numerous hyperlinks in cells on a worksheet, next to these I have checkboxes. I am looking for a macro that will check if the boxes are checked and if not ignore them and if so run a certain macro.
View 6 Replies
View Related
Aug 27, 2009
I was looking for a final result as follows
21-Aug-09 + 1 = 24-Aug-09 (Day + next 1st working day)
21-Aug-09 + 3 = 26-Aug-09 (Day + next 3rd working day)
View 2 Replies
View Related
Jun 29, 2007
I designed some userforms on a worksheet for users to click and input information. However, i am wondering if it is possible to have an additional feature to the userform.
Currently the userform only have labels such as Title, Dept, Branch, Unit and the respective textboxes for user to input information. As it might be unclear to some users i would like to have an additional feature such that when user roll their mouse over the label "Branch", the user will see a box where more information is given or rather an example such as "Dept XYZ", allowing user to have a clearer idea of what to fill in. Is there any way for me to add this feature?
View 10 Replies
View Related
Oct 9, 2009
I have a form where there are a lot of check boxes and there is a print version button. It is so when you complete the form you click print preview and it removes all the unused lines and formats the form to be ready for print. Everything was working fine until I had to add another line of check boxes and now first row skips a cell after formatting.
View 5 Replies
View Related
Feb 23, 2012
I have made a calendar in excel, and need to make the following work.
I have six boxes (each for one day of the week, excl. Sunday) and a separate box containing names. I need to come up with a way that excel will automatically add those names to any five of the six boxes at random (always leaving exactly one box free for each name), and always choose which box at random.
View 1 Replies
View Related
Feb 27, 2008
how many boxes i will need?
in column D, i have the QTY of a product
In Column F, i have the QTY/Box
i need a formula that will tell me how many boxes i need..
i Tried =SUM(D9:D1500)/AVERAGE(F9:F1500)
however, it just doesnt look right.
View 9 Replies
View Related
Mar 21, 2008
I don't know if input boxes are what I want but you'll be able to tell me
When Excel is opened, I want a box to pop up where the following can be pasted:
"Trades
Merchandise: 100,000.000
Merchandise: 1,000,000.0000
Merchandise: 1,000.0000
Merchandise: 10,000.0000
Total: 1,111,000.0000"
The text and numbers will be copied from a webpage. When Excel is then opened, rather than having to type in those values (I'm only interested in the numbers), could an input box (or something else) handle and filter those lines to basically just the numbers?
View 9 Replies
View Related
Jan 13, 2010
I have created a dialog box for entering data into once that data has been entered i want the dialog box to store the data into a separate worksheet at A2 in then want the dialog box to clear and reappear ready for new data to be entered. This new data would then need to be entered at A3 etc etc etc. Is this possible and how would i go about doing this.
View 9 Replies
View Related
Feb 22, 2014
How can I add the pause between count & boxes?
VB:
s.Speak count & "boxes for scanning!"
View 6 Replies
View Related
Sep 26, 2007
This is a repost, I would like to add a comment boxe in multiple sheets (same cell) in a work book. Someone reccomended a macro but then my post was removed.
View 12 Replies
View Related
Oct 22, 2008
Adding new items to the list, and then sorting them, I've found that the drop down boxes which I was oh-so-happy to utilize... don't move with their relative rows when the item name or department is sorted. IE. The option to select Supplier 3 for Thing 4, stays where it is if you sort by department, giving incorrect options. how to sort this while moving them, or on an alternative menu box system which would sort?
View 2 Replies
View Related
Feb 4, 2009
For example:
Locking a certain text boxes, and not others. Under review, protect sheet, the Edit Objects function is all or nothing
View 2 Replies
View Related
May 13, 2009
I am trying to link 'Combo boxes' in Excel 2007 (not using code as the guy in the other thread is). Ie In the first drop down box you choose the type of cement, then in the second drop down box, different mixes of cement can be chosen DEPENDING on your choice of cement in the first.
View 14 Replies
View Related
Nov 24, 2008
I m creating new tabs that users input into a text box and two label: one each becuase one tab will be Tab1 then then other label will be Tab1 Completed.
How do you continously update the label so it changes as the user inputs letters.
I never used text boxs before so thus another reason I have no clue.
View 2 Replies
View Related
Jun 2, 2009
I'm creating a form, that will contain 20-30 tickboxes. Each of these tickboxes will refer to a certain row on a seperate sheet. And it will either hide/un-hide depending on if it is tick/un-ticked.
How can I in the macro know which of the tick boxes that was ticked?
View 11 Replies
View Related
Sep 18, 2009
I have a manualy constructed user form which has 3 data validation lists.
Sources:
B7 = List 1
B12:B15 = List 2
B17:B20 and C17:C20 = List 3
These operate fine but I wish to replace the dropdown validation boxes and replace them with Combo boxes so that users are able to view the complete lists and also offer the option of inputting an item not included in the validation list if required.
I have tried many variations of input but my knowledge base is inadequate!
Mainly I end up with the combo box working on one cell only!
Can tell:
1. Do I have to raise 1 combo box per cell?
2. What vba code is necessary to make them all work?
View 10 Replies
View Related
Jan 13, 2010
I created a combobox on the fmEdit userform that I want to use to select a name from the worksheet and display on the Userform the data from that row for editing, which can then be submitted to make changes accordingly on that row.
View 7 Replies
View Related
Jan 15, 2010
Am trying to use a VLOOKUP in VBA on a form, I am entering data in one field so data will be displayed in another field. They are both text boxes. Here is the code;
View 3 Replies
View Related
Sep 9, 2009
I did away with the merged cells, and now I have a combo box in every cell that I want it in.
My problem is, I would like to format each combo box seperately. Every cell that has a combo box in it has data vakidation activated. I copy and pasted code to get it to work. It works great, but I would still like to change the combo box size and tab and enter functions for each individual one. I created more than one combo box but I kept getting an error on them. Any help or knowledge would be greatly appreciated.
I am posting just the code that I copy and pasted.
View 12 Replies
View Related
Oct 20, 2009
I have created a Time Sheet for calculating the work hours of employees. There are various criteria which play a role in how work hours and wages earned are calculated (ex. time, over time, LOA, Travel time, stat holidays etc etc.)
In a certain cell I have placed a tick / check box which the user can tick to indicate that that particular day is a statutory holiday. The tick creates a True / False answer in another Linked Cell.
Based on the True / False result I have a formula which, using the IF function with multiple conditions whether the result is True or False, will calculate the hours worked for Regular, Time and Half and Double Time.
The Formula itself works but when I add the condition based on the check box - example: IF(c37=TRUE,...,if(...,if(...,IF(c37=FALSE,...,if(...,if(... and so on, only the TRUE option works. As soon as the check box is "unticked" I get the result "false".
I hope that all makes sense.
If it helps this is my formula... where C37 is the linked cell for the checkbox.
=IF(C37=TRUE,IF(B10<4.1,B11,IF(B10<8.1,4+(B10-B11),IF(B10<12.1,B10-B11+4,IF(B10>12,8,IF(C37=FALSE,IF(B10<8.1,0,IF(B10>8,IF(B10<12.1,B10-B11,4)))))))))
So, when the check box is ticked, the TRUE argument works fine. But when the check box is not ticked I get a "false" result.
View 14 Replies
View Related
