Help with Missing and Broken Code

**MyForcey** · 12-27-2023, 04:03 AM

Good Day All!

I have attached the workbook in question.

Could someone assist in completing or fixing my code for the UserForm?

So, I have managed to make the UserForm add data to the table, and I can select it from the ListBox in the UserForm and it will populate the form. Great.
However, I am coming across issues when I want to edit - if I select the item I want to edit, the ListBox doesn't show me all data with the items selected, instead it shows the items selected only (But they are unchecked) I can't seem to uncheck and check another one should I wish to edit. - I think I might need to change the delimiter as well.

I also have UserForm12 which is similar to how I want the search and formatting on the ListBox in UserForm1 - the search button should allow me to search anything within the defined range.

And I am really struggling to find a way to keep a log of the data and add it to a table within another sheet - incase I need to look up what the old figures used to be...

Please can someone assist me?

**Tajan** · 12-27-2023, 01:13 PM

Add this procedure to the UserForm1 module:

Please Login or Register  to view this content.

Line of procedure "PopulateUserformControls":

Please Login or Register  to view this content.

change to:

Please Login or Register  to view this content.

And similarly the "listboxSearch_Click" procedure line:

Please Login or Register  to view this content.

change to:

Please Login or Register  to view this content.

I assumed that the delimiter is a semicolon.

**MyForcey** · 12-28-2023, 03:32 AM

Hi there, thank you - the listbox is definitely working better.

But now the btnADD procedure keeps crashing excel and I don't think the search btn is working.

The edit button I wanted to - for example - click once to allow edits then click again to confirm the edit?

appreciate the help.

**Tajan** · 12-29-2023, 09:37 AM

But now the btnADD procedure keeps crashing excel

In the "btnADD" procedure, before the line:

Please Login or Register  to view this content.

insert:

Please Login or Register  to view this content.

and before the line:

Please Login or Register  to view this content.

insert:

Please Login or Register  to view this content.

I don't think the search btn is working

How is search supposed to work? In which columns?

Help with Missing and Broken Code

LinkBack

Thread Tools

Rate This Thread

Display

Help with Missing and Broken Code

Re: Help with Missing and Broken Code

Re: Help with Missing and Broken Code

Re: Help with Missing and Broken Code

Thread Information

Users Browsing this Thread

Similar Threads

Broken Code. Web Data Pull

Code Seems Broken Since Beginning Of Month

Code for adding section broken - help!

find and delete row code broken...help!

Tally Macro: Broken Code

Copy web page with VBA code- broken

VBA code to validate Broken links of a web page

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions