unable to resolve error 424

**rickmeister** · 04-27-2017, 01:34 PM

Dear,

Can anyone help out? I'd like to open a form but I get the famous 424 error - object required: many thanks!!!
I do have a form called Mapper in the forms tab in vba

Sub Auto_Open()
   Mapper.Show
    Dim SourceFlag As Boolean
End Sub

Private Sub UserForm_Initialize()

 'Recreate defined names
 Module1.createDefinedNames
  
 If Sheets("Control").RememberLastMappedField = False Then
        ActiveWorkbook.Names.Add Name:="startField", RefersTo:=2
 End If
 r = Replace(Names("startField").Value, "=", "")
 
 
 StartFlag = False
 Description.MultiLine = True
 'RWCriteria.MultiLine = True
 Issues.MultiLine = True
 Code.MultiLine = True
 Validation.MultiLine = True
 Comments.MultiLine = True
 SourceFlag = True
 ClearButtonPressedFlag = False
 'Mapper.IssueStatus_CB.List = Array("Open", "Closed", "")
 'Mapper.issueSeverity_CB.List = Array("1 - High", "2 - Medium", "3 - Low", "")
 
 UpdateCaption
 
 StartFlag = True
 ClickCount = 0
 
 'Me.ComboBox1.AddItem "Direct move"
 'Me.ComboBox1.AddItem "Default value"
 'Me.ComboBox1.AddItem "Write criteria"
 'Me.ComboBox1.AddItem "Data Transformation"
 
   
End Sub

**Richard Buttrey** · 04-27-2017, 01:39 PM

Hi,

Which line is current when you get the error message?

**rickmeister** · 04-27-2017, 01:39 PM

Mapper Show gets highlighted...

**Richard Buttrey** · 04-27-2017, 01:45 PM

Originally Posted by rickmeister

Mapper Show gets highlighted...

In that case and since you say you do indeed have a form object called Mapper we'll need to see the workbook.

**rickmeister** · 04-27-2017, 01:53 PM

hope it works uploading the file. Idea is that the forms gets populated and by clicking on "save" all values are being copied and saved in to the mappingdata sheet.
But first thing is to be able to open the form ;-)

**jomili** · 04-27-2017, 03:21 PM

I tried walking through the code, hitting F8. Doing it that way you can pinpoint where in the process of calling up the form it's hitting an error. Looks like it's in your "Update Caption" macro, I think (it happens fast) on the line saying:

FK.Text = Worksheets("MappingData").Range("Y" & r)

**Richard Buttrey** · 04-27-2017, 04:14 PM

Originally Posted by jomili

I tried walking through the code, hitting F8. Doing it that way you can pinpoint where in the process of calling up the form it's hitting an error. Looks like it's in your "Update Caption" macro, I think (it happens fast) on the line saying:

FK.Text = Worksheets("MappingData").Range("Y" & r)

Yes indeed so.

What is FK.Text meant to be?
and indeed what are PK.Text and Complexity.Text since the macro will also fail at those.

**rickmeister** · 04-28-2017, 04:46 PM

Fixed! indeed I uncommented those lines, many thanks!

unable to resolve error 424

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

unable to resolve error 424

Re: unable to resolve error 424

Re: unable to resolve error 424

Re: unable to resolve error 424

Re: unable to resolve error 424

Re: unable to resolve error 424

Re: unable to resolve error 424

Re: unable to resolve error 424

Thread Information

Users Browsing this Thread

Similar Threads

unable to resolve a #NUM! error message

How can I resolve this VLOOKUP #REF error?

[SOLVED] Help to resolve Run time Error 380

[SOLVED] Unable to resolve #DIV/0! in sumproduct function

Unable to resolve Runtime error 91

Add ISERROR to resolve DIV/0 error

Bookmarks

Bookmarks

Posting Permissions