Private Sub UserForm_Initialize() Problem

This is very interesting.

So I will look at this for you.

Thank you all for your replies, where do I insert the Listbox2 code you first mention? Is all of this supposed to be inserted into the initialize part of the code? Should anything you have quoted replace any of the existing code?

If you post your spreadsheet with instructions.

Then I can modify your code for you.

Thanks Norrie,

I will adjust my code to use Join.

Hello all and thank you for your help. The spreadsheet is attached as requested.

UserForm for Export.xls

Details of data entry and functionality were included in my previous post when you (very kindly) joined the thread.

mehmetcik, where are you resident expert? I have answered your questions and provided the file you asked for. Thank you for your help in advance.

Thank you so much for your reply

What do you mean by toggle button for Search/Edit mode?

The spreadsheet holds data in the sheet 'DataTracker', data is managed by using the userform to input and delete entries and at the moment the only way to scroll through the data by pressing the left and right navigation buttons towards the top. Typing in new information will automatically be added to the first blank row in the spreadsheet when the save button is pressed. The delete button should remove the currently displayed data row from the spreadsheet.

I am trying to get the userform to load the spreadsheet data into the right hand column entitled 'Account List'. By default when the form is loaded the data from the spreadsheet appears on the userform.

How do I get the 'Account List' colum to auto-update when data is entered on the left hand side and saved to the spreadsheet?

I haven't figured out how to get the other two navigation buttons working to go to the very first and last data rows in the spreadsheet.

I also want to be able to switch between rows by selecting something from the list appearing on the right hand side.

Lastly, I want to be able to reorganise the data appearing on the left hand side (and spreadsheet) by either clicking and dragging and releasing the mouse button or if this is not possible/in addition by using buttons.

Try this Spreadsheet.

NB: I used another macro to help me write the Userform Subroutines.

I am attaching that for you to look at too.

Hello mehmetcik, well that's pretty impressive! Thank you so much

I wonder, is there a way there can be a tick box to enable/disable to 'Are you sure you want to delete' prompt?
Also, can switching between records be activated by default when editing as well as 'searching'?
Is there a way to select a row in the 'Account List' column and by entering and saving data in the left hand side it puts the new data in the row below and moves all other data down to make space for this?
What is the blank box below the 'Account List' column for?

Finally, how do I get the sort buttons to move the current row up and down the spreadsheet?

if you change records during editing you will lose your data.

Is that a risk you want to take?

So you want to insert new data under the selected row?
Presumably for keeping family records together.
That is easily done.

Highlighting the selected record in listbox,
I tried that yesterday, I could not get a robust solution so I removed that.
I will try again/

I can use a togglebutton yo enable and disable prompts.

Hello Mehmet,

Thank you for your fast reply. I am prepared to take that risk, could always have a prompt come up in instances where data has been entered but not saved, allowing the user to decide whether to save or lose progress before switching records.

You have the right idea with all of this. New data under the selected row would be best, if we can get the 'sort' buttons working then it would be possible to move the data if it were inserted in the wrong place. Moving data around should happen when the button is pressed and this change should be made permanently by automatically saving the change in the spreadsheet.

Toggle button would be great, perhaps a menu item could be introduced, like 'Preferences'?

It would be great if highlighting could be sorted.

Thank you so much for all your help.

Try this version.

Hello mehmet, that function seems to be working well, thank you!

Can you please help to get the 'sort' functionality working to organise the data showing in the account list?

Can you please enable amendments during 'search' mode and have a prompt come up in instances where data has been entered but not saved, allowing the user to decide whether to save or lose progress before switching records? The arrows should also allow the user to view the first/next/previous/last record with the same prompt appearing if there is unsaved data.

Can the arrows for changing the data currently being viewed also be enabled in all instances?

Is it possible to make the 'Enable Prompts' button into a menu item, which would appear under 'Preferences' in a drop down like in a normal application?

Thank you for your fast reply.

The sort buttons should move the current selected row up and down the spreadsheet and up and down the list, with the move being saved each time to maintain its new position (without a prompt).

Ok

I've added some additional functions.

Hello there, thank you for the update. The sort functionality appears to work well. The 'Find Entry' button appears to wipe the 'Account List' from view, what is that button supposed to do?

Thank you for dealing with the prompt too, which also works well. When there is information entered but not saved, is it possible for it to ask 'You are about to move to the next row, would you like to save your new entry?' and then Okay would save and Cancel would move to the next row without saving progress.

Hello Mehmet, I imagine that you are really busy, just wanted to check that the points previously raised were still on your to-do list?