Using VBA Set for workbook and worksheet

[StudentJacks]

Yes, the button is there and works.

This line:

Set tbl1 = ws.ListObjects.Name = "TableX"

should be

Set tbl1 = ws.ListObjects("TableX")


Also, TableX is pulling only 4 columns. Sub txtbox1_AfterUpdate() expects 6. Resize TableX to include columns E and F.


Why do you have combobox on worksheet instead of just using the form as interface?

I was trying to try to filter to find a record in a timely fashion instead of scrolling through 300+ records to find the one I was looking for. I also thought this would be the fastest way to copy the Username & PW to paste on the websites logon page.

Thank you so much for your patience and expertise. Your solution worked and everything is working as I hoped. Happy Holidays to you and your family.

[June7]

I made a number of edits to previous post, probably while you were reading. Might review again.

Glad it helped.

Enjoy your holidays.

[StudentJacks]

When I try to delete the TableX name in name manager the delete option is greyed out. Do you know how I can fix that?

I have tried numerous programs and vba code to delete the TableX named range without success. Each and every one of the solutions tried doesn't recognize the name range and/or doesn't show it in the list of available names.
On of the vba codes I tried is:

Dim wb As Workbook
Dim nr As Name
Set wb = ActiveWorkbook
Set nr = wb.Names.Item("TableX")
' give an absolute reference:
nr.RefersTo = "=MasterData!$A$3:$G$400"  error reads Run-time error'1004' Application defined or object-defined error
End With

I am not sure where to go now. Maybe you have an idea?

[StudentJacks]

When I try to delete the TableX name in name manager the delete option is greyed out. Do you know how I can fix that?

I have tried numerous internet VBA codes and programs to remove the TableX named range but none of them work. In fact, the only range names the programs show are the DropDownList and the Table2 names. None even show the TableX name as being there. Hmmmm.

[June7]

Why delete the TableX, just resize its range. https://support.microsoft.com/en-us/...%20press%20OK.

Otherwise convert then delete https://support.microsoft.com/en-us/...a-786265d41c77

[StudentJacks]

Why delete the TableX, just resize its range. https://support.microsoft.com/en-us/...%20press%20OK.

Otherwise convert then delete https://support.microsoft.com/en-us/...a-786265d41c77

[StudentJacks]

Thank you so much. I did not know that the option to convert (resize table) as available.