I have 2 User forms which take their initial values from the same worksheet. One moves stock to another location, the other removes stock when it has been used.
When I use one of the forms on a different row, or switch to the other form it retains the last row's values until I click on the new worksheet row twice
How can I prevent this?
Private Sub CommandButton17_Click()
If UserForm5.Visible = True Then
Unload UserForm5
End If
If ActiveCell.Row = 1 Then
MsgBox "Cannot Use This Row, Choose A Different One"
Exit Sub
End If
UserForm4.Show vbModal
End Sub
Private Sub CommandButton18_Click()
If UserForm4.Visible = True Then
Unload UserForm4
End If
If ActiveCell.Row = 1 Then
MsgBox "Cannot Use This Row, Choose A Different One"
Exit Sub
End If
UserForm5.Show vbModal
End Sub
I won't post the form code here yet as both are quite large. Maybe someone has encountered this issue before?
So I have a work book with a number of user forms. One form I have completed has several navigation buttons (previous, save, next......) a couple of drop downs and a "tabbed" (pages) area with a text box on each. I think I finally have it looking (and working) the way I want. The issue is I need 12 more that are Identical (different text - but layout and code is the same) To make them look and work the same how can I copy the one I have correct? Is Export/Import the way to go? Does that bring all the code?
I am trying to graduate out of the crayon age of menus on a worksheet, to using a User Form Menu. Problem is, I don't understand how they work. I've created a test program using a simple form with an option button, a combo button, and a command button. The goal is if the option button is true, it places the color selected in the combo button on the worksheet. Here is my code, what am I missing to make it work?
My problem is trivial but annoying. When I initiate my user form, one of the check boxes has a dashed border around the outside as if it was selected. No matter what I try, I cannot get the form to initialize without effecting this box. If I delete the box and recreate it, another box simply inherits this problem.
I have attached the spreadsheet, please Click the button over "A1" to see what I mean if you have the time.
I have a userform, when it first comes up, then there are some text boxes that needs to be filled. I have the "ok" button which opens another form. What would be the code for whatever was filled in the text box be pasted in a cell? In other words, once it is ok is clicked another form pops up and then whatever info was put in the text boxes is pasted in a report.
I am making a user form so that others can enter their data into a database. In some of the fields I want to have a drop down list that will contain both all the options from a generic list, and any other items that have previously been entered into that field. For example I have a generic list of components but someone may feel that none of those listed describe their component so they will add a new one, I want this new one to then appear within the drop-down list for the next user,
I need to create a user form that will "pop up" and ask the administrator to enter the above details.
A - should be created automatically (ie last claim number + 1) B - user enters manually C - data retrieved from a list D - data retrieved from a list E - date is the date the information is entered
I am using a calendar control 11 in a user form. I would like to create a combobox on a user form that when you click the drop down button it opens the calender then the user can select a date which is then returned to the combobox. I beleive the way to do this is to trap the dropbuttonclick event. Tho it dosent seem to work.
Private Sub ComboBox2_DropButtonClick() Calender.Show ComboBox2.Value = Calender.Calendar1.Value End Sub
In VBA i have 3 userforms, the first 2 take the data and store them in variables. The 3rd form is supposed to take the variables from the other two forms and do some calculations with them. Although i cant get the 3rd form to take the stored variables from the other two forms. Is there a way to use stored values from other userforms?
User Form Basics - Populating Text Boxes. A few tweaks later and its reading the data just fine. Some of the specific form objects and range names have changed, but it's the same logic.
Anyway, this isn't just for display. I need to export the data back to the spreadsheet. So, I plugged this line into the event handler for the "Save & Exit" button on the sample form in the other thread:
I'm having a problem creating a Reset All command button that will remove user entered unlocked cell values from an entire workbook save for one specific worksheet. So for example, I have five tabs labeled as "DTF", "Week 1", "Week 2", "Week 3" and "Week 4". I want one single command button (placed in the "DTF" worksheet) to remove all of the unlocked cell values from "Week 1" to "Week 4".
I have a little knowledge of Excel Programming and I am seeking advice and help. With reference to the http://www.exceltip.com/st/Create_Us...Excel/629.html, I managed to create the form but I somehow couldn’t get it executed. Attached herewith my file for evaluation.
I would have like a chance to be able to remove the apparent potenitial dangerous problem from the thread below and not close it after 10 mins. I'm not on the site permenantly and keep dipping back in eveynow and again. I dont know what the issue is as when I open the file up I dont get any error messages. I have tried this on my machine using Office 2003 and Vista also another PC using Office 2003 and XP
[url]
The only error I get is a message saying Disk or Network error, when testing it on the XP Machine this is because doesnt have access to the Database it sends the data to.
sometimes pivot tables won't give me the details I want the way I want. any time my boss asks me for a monthly report I have to do everything manually from the pivot table and insert the data on another table where I put the filteres data. I want to be able to get a monthly sales report per store that will populate itself in a daily basis, I also want to be able to select a store, style, size and date from a form in Excel and see the report in a sheet. Aproblem that I have found in order to use the size as a parameter is that the size comes in the same line as the item description and do not know how to make excel to check just for the size in the description field. The attached file contains sales data for a better understanding of my case.
I have created a form which is called up via a macro and then shows a combobox which contains the names of the worksheets in the workbook. I am trying to enable the user to select one of the worksheet names from the combobox and then store that name (the book does not have fixed sheet names) and continue with the original macro using the stored name. I just can't figure out how to use the selected name in the original macro.
I have created a form to input parking ticket data to a spreadsheet, it all works exactly as i want it to, but i really need it to tell me the next available number or empty line, so i can use that for filing and audit purposes, ideally i would like it to do sequential numbering, but i've been looking for weeks and cant find a soloution, i have basic knowledge of VBA and i'm really struggling with this,
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.
I 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.)
I would like to know if it is possible to display a form using a variable containing the form name rather than the form name itself, I have tried everything I can think of and cannot make it work. I know I can use CASE SELECT but I have a large number of forms involved and would like to use a variable name if possible.
I have checkboxes in N85:N100 and O85:O100. When I use the following code, it gives the same link in N85 and O85. How can I put a specific rannge so that it will only do N85: N100 and then do O85:O100.
Sub change_forms_checkbox_links() Dim mychkbox As CheckBox Dim wks As Worksheet Set wks = ActiveSheet
I am trying to put together two combo boxes, Combo1 and Combo2, the content of Combo2 will depend on the selection made in Combo1, for example Combo1 will have 10 items, once an item is selected Combo2 will have different sub selections relating to that item. I know you can do this via Validation, but the problem with that I have about 4000 options in the combo1 and about 60000 in the second, here is the structure of my data:
1) I have a scrollbar that gets set to UserForm1 height.... yet, if the form is taller than the page, it won't let me scroll down past what I can see on my computer screen... what would be the cause of that? I get a blinking black light on the scroll bar as well so there must be something I need to fix with that
2) In UserForm1, I have a multipage form with a page called Accounts... I am adding check boxes to it with code... right now it is adding it to the far left in UserForm1... what is the syntax to run my check box loop to populate the Accounts page in the Multipage form?
I've been creating forms/questionnaires, customer satisfaction type tings with Excel after I discovered that the previous ones were done on paper and it’s now my job to crunch the numbers for a report.
While I've been off learning how to do this in a suitable way for the office I work at, I've been neglecting the stack of papers from previous customer satisfaction surveys that are building up on my desk, about 200
So now rather than do what I think everyone else would do and make up the numbers. I thought I would just make a excel book with buttons for all the possible options on the survey and click them as I look through the papers.
So I need to learn how to make a button that, when clicked it would add a number to a cell. So if I clicked it 10 times, that cell would show 10.
so I can make the form with the buttons, what code/formula will I need to assign to the button to make it +1 to say, sheet2 A1?
I have spent a long while trying to figure out what i'm sure is a very simple problem. I have searched the archives and found nothing to specifically address my question.
Basically I am trying to export the data entered into an Excel form into the fields of a Word document template, so that i can print it according to a particular design.
I have managed to write the code successfully enough that the data is transferrred across to the right fields in Word, but I can't seem to work out how to transfer the subsequent rows. It is currently only exporting the second row (after the header).
Could anyone possibly look at my code and tell me how i can export the new values every time they are entered in the form and not just the first line?
Private Sub CancelButton_Click() Unload Me End Sub Private Sub Save1_Click() Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("RA") 'find first empty row in database iRow = ws.Cells(Rows.Count, 2) _ .End(xlUp).Offset(1, 0).Row
