i have a user form which is activated by a button. when this button is clicked excel crashs every now and then. i get an error message run time error 75, could not find object. it asks me to debug or end. whatever option i choose when i try to save the worksheet there after excel crashs and closes. any body else have this problem, what could be the cause?
View 6 RepliesMy excel file triggers excel to crash after clicking the only button on my worksheet. The button displays a userform.
However; this does not always happen. It actually drives me crazy as I don't find the solution to my problem. My company were I work upgraded my Excel 2003 SP2 to Excel 2003 SP3 which seemed to help but now the same problem returned...
I found a temporarily workaround though; when saving the file first (right after I opened it) it doesn�t crash when showing the userform. Very strange (to me).
Here is my file: ....
When loading my workbook, my userform loads perfect, but when I go to hit the "next" button. It crashes with the error:
"Path/File access error."
The next button code, quite simple: ....
I'm trying to do is set up a form load event to initlize some controls. Here is my
Private Sub Form_Load()
'Initialize the form
lblProcessing.Visible = False
txtFileName.Text = "Enter a file name"
End Sub
At the moment, this event is not triggering. I have the code in the code behind my form - should it be in a module? PS: This site is great - it's answered a lot of my other questions so far without me having to make any posts.
It is a simple form which has a Module/Macro to load the form on clicking a shape.
Although the form works fine for me it occasionally crashes for other user.
The Debug says that there is an error in the Module with the line "frmCallData.Show".
Below is the Code for the form and also the Module: ....
I worked really hard on this userform for a work project - my first and likely last attempt at coding!
It used to work, and then I changed a bunch of listboxes to comboboxes, and now my file gives the 'Excel has encountered a problem and needs to close' error - but ONLY when I'm working directly with the excel file and NOT when I've got VBA open.
Compiling shows no problems - I have no idea what to do because this is a very important file for work and I am a very inexperienced coder! ...
how I can pass a value to this function. For example I know the record id that I want loaded, it is 42, so I want to create a button that brings up record id 42 when clicked. I think to do this I would load the form, then call cmbSelect() and pass it Me.TextBox1 = Value "42", but I am not sure on the syntax on how to do this
Private Sub cmbSelect_Click()
Dim r As Integer
Dim cell As Range, rngRecord As Range
' Locate indicated record
For Each cell In MyData
If CStr(cell) = Me.TextBox1 Then
For Each rngRecord In cell.Range("B1:AS1")
If rngRecord.Offset(-rngRecord.Row + 1, 0) <> "" Then
Me.Controls(CStr(rngRecord.Offset(-rngRecord.Row + 1, 0))) =
Code:
Private Sub Userform_Initialize(Change As Boolean, Optional Brand As String)
I want to load a userform with arguments, is this ever going to work?
I have an userform, with a label and several commandbuttons(for instance, command button A, B, C, ...) . Now if I click the command button A I would like to load in the label A text previously written in sheet1 range A1, if I click the command button B I would like to load in the label another text previously written in sheet1 range b1 (the old text shouuld obviously disappear)
View 7 Replies View RelatedI have a UserForm appear when the user opens my file. It prompts them to enter some data. If they Close (Terminate) the Window, I have a MsgBox appear telling them they must enter data - and allow them to go back or exit. When they opt to go back the UserForm reapears but Excel freezes and I have to force quit.
Here is the code for my UserForm, including the Sub for when the User clicks OK (CommandButton1) and the Sub for when the User terminates the window:
VB:
Private Sub CommandButton1_Click()
Dim Blank As Integer
Dim Subgroup As Integer [code]....
I have tried a couple things to get this image to show up on my userform and i keep erroring out.
Run-time Error '404' Object required
If i hover over the "userpic" in debug it has the correct referance, its just not doing anything.
Any help or suggestions would be great.
-LightData = Userform
-Pictures all held on sheet5 of wookbook
(I've search and looked at all the threads, which actually lead to what i have below)
Private Sub ComboBox1_Change()
Dim RowOffset As Integer
RowOffset = ComboBox1.ListIndex
userpic = ComboBox1.Text
LightDate.Image1.picture = Sheets("sheet5").Shapes(userpic)
TextBox1.Text = Sheet1. Range("c2").Offset(RowOffset, 35)
CheckBox1.Value = Sheet1.Range("c2").Offset(RowOffset, 37)
CheckBox2.Value = Sheet1.Range("c2").Offset(RowOffset, 38)
CheckBox3.Value = Sheet1.Range("c2").Offset(RowOffset, 39)
CheckBox4.Value = Sheet1.Range("c2").Offset(RowOffset, 40)
CheckBox5.Value = Sheet1.Range("c2").Offset(RowOffset, 41)
CheckBox6.Value = Sheet1.Range("c2").Offset(RowOffset, 42)
CheckBox7.Value = Sheet1.Range("c2").Offset(RowOffset, 43)
CheckBox8.Value = Sheet1.Range("c2").Offset(RowOffset, 44)
CheckBox9.Value = Sheet1.Range("c2").Offset(RowOffset, 45)
CheckBox10.Value = Sheet1.Range("c2").Offset(RowOffset, 46)
CheckBox11.Value = Sheet1.Range("c2").Offset(RowOffset, 47)
End Sub
I have a workbook with images and have created a userform using VBA in the same.
I wanted to load a picture in the userform from the images on sheet 3.
I included a couple screen prints showing that the form exists, and that it is not misspelled in the code. What should I look for?
View 4 Replies View Relatedwhy is this giving me a type mismatch error?
Sub loadMenu(menu As UserForm)
Load menu
menu.Show
End Sub
i have a userform which has txt boxes in it which when the data is put in to it goes onto a sperate worksheet.
would like to click on a command button to view the worksheet that the data has gone onto
have tried
unload me
sheet1 show
unload me
sheet1.show
and also with the worksheets name as well
I have an image box on a userform in Excel VB. Is there ANY WAY to load an image into this image box from an object that I have loaded into an excel worksheet something like
If userform1.checkbox1=True Then
userform1.image.picture = loadpicture (Worksheets("Sheet1").shapes("Object 1"))
ElseIf userform1.checkbox2=True Then
userform1.image.picture = loadpicture (Worksheets("Sheet1").shapes("Object 2"))
Else
msgbox "No image"
Endif
I need to do a macro that will open a search window, the user would select a folder and it will search for a .csv file within it. Then after locating the file, it would automatically load it into a specific sheet in the workbook.
View 9 Replies View RelatedI have a list box that I'm using to pull customer information from my "Customer" sheet to my "Invoice" sheet. I can actually open, select, and close the userform. However, I can't get the macro to put the information into the specified location on my "Invoice" sheet.
Here's my code so far:
Private Sub Cancel_Click()
Application.ScreenUpdating = False
Unload Me
End Sub
Private Sub customer_Change()
End Sub
Here is the "Customer" sheet I'm pulling the info from:
And here is the location on the "Invoice" sheet that I'm trying to direct the userform to:
And here's my userform just for reference:
The userform works perfectly until I press the OK button. That's when I get the error.
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
Application.ScreenUpdating = True
Unload Me
RestrictedOptions.Show
Else
Cancel = True
End If
End Sub
Trying to use above code to unload active userform and show new userform when red X (close) selected by operator. With the code as is, the Unload Me leaves the form on the screen and displays the RestrictedOptions form. If i remove the Restrictedoptions.Show, the Unload Me does remove the original form.
how do i show a userform in Excel in the spreadsheet environment? I used to "run macro" but unable to run userform code "private sub".
View 2 Replies View Relatedhaving trouble with the details of actually making these features work for me. I figured out how to create a UserForm with a ListBox and 2 buttons, but I don't know how to proceed from here.
1. Populate the ListBox in the UserForm with a list of names from the sheet "Totals_Dropdowns", cells K2:K11
2. Make the UserForm pop up and enter the user's selection into cell C40 of the "Regenerate Request"
I know these are very basic operations, and I'm pretty sure I can figure out the rest of my problems once I can get past the above.
I have a userform button that when clicked loads another userform.
I am getting a Runtime Error 13: Type mismatch on the line in bold in the code below
Private Sub cmdAdd_Click()
Me.txtAdd.Value = Me.VarNo.Value
VariationsForm.Show
Unload Me
End Sub
I do not get an error on the "Edit" button code which is similar so why is the above not working.
Private Sub CmdEdit_Click()
Me.txtEdit.Value = Me.VarNo.Value
VariationsForm.Show
Unload Me
End Sub
I want to use the following to launch a userform I created.
Sub showuserform()
Dim ans As Boolean
ans = msgbox("do you want to show the userform?", vbYesno)
If ans = vbYes Then
userform.show
End If
End Sub
The trouble is that if I click yes, nothing happens.
I have data in range J2:J365 , H368:H401 & J403:J827. i want to check wether this range have negative values or not if yes load all negative values in the listbox1 by clicking checkbox.
View 3 Replies View RelatedI'm trying to show a form from inside another form. Example: form1 has a command button and when clicked, I want it to show form2. But I always get a run-time error '32': type mismatch.
View 5 Replies View RelatedI want to UserForm.Show and minimize Excel at the same time then restore Excel when the Form is closed.
View 4 Replies View RelatedI have worksheet with cell A1 always change simultaneously (input from other source), in cell A2 I put formula, so value in A2 always change depending value in cell A1. The problem is I want to show that value A2 in userform VBA. I tray using textbox (in property textbox control source I set to A2) but not working because Cell A2 change from formula to static value.
View 10 Replies View RelatedI have a userform that is working perfectly, but when I try to make it an add-in I can't even get it to load. When loading the userform as an add-in I get the error "Run error nr. '9'.: The Index is out of the interval" (freely translated from Swedish to English). The code I'm using to load the userform is
View 3 Replies View RelatedI have a userform with multiple tabs. I have buttons on the excel sheet that correspond with the tabs. How do I get the buttons to open up their respective tabs in the userform?
For example: Button 1 opens Userform-Tab1; Button 2 opens Userform-Tab2; Button 3 opens Userform-Tab3; etc.
Right now they all open the userform, but open the first tab.
I have created a user form where I have two Dates fields. Date Leave (three comboxes, CmbDay, CmbMonth and CmbYear) and then I have written the following code
Private Sub Label4_Click()
If CmbDay.ListIndex -1 And CmbMonth.ListIndex -1 And CmbYear.ListIndex -1 Then
If IsDate(CmbDay & " " & CmbMonth & " " & CmbYear) Then
MsgBox "You selected " & Format(CmbDay & " " & CmbMonth & " " & CmbYear, "dd/mm/yyyy"), , "Date selected"
[Code]....
I have got the code from there.
But I want the show the same date field in another field as Date Join. I have changed the names of Combo Boxes but it is not working.
I want to show the same combo boxes in another field. How do I do that?