VBA userform search and update

Hi Sazza, I looked but did not see edit/trans userform

Try this code for "Search Trans" button

Please Login or Register  to view this content.

I'd do something like below. It would be faster, if transaction list becomes large.

Please Login or Register  to view this content.

Thanks CK76 - that's works perfectly - Thanks a mill

Sorry nigelog I haven't assigned it a button a yet - getting ahead of myself

Thanks Kasan

CK76 - How do I write out any changes using your array ?

I was using

Please Login or Register  to view this content.

I looked at it quickly and just had a thought that you would need to know the exact date which is restrictive. If you could get the search transaction button to return all records for the member, from a date, to a listbox and use a double_click event to open the details in a userform and record any changes back to the transaction overview sheet. I got round a similar problem recently by this method and didn't take much extra work......

I was thinking the same thing tbh but as im only learning I will try get my head around this exact date way first then tackle the lsitbox method ..

CK76 - How do I write out any changes using your array ?

You'd store "i" when record is found, and use that to return info to sheet.

So if record is found when "i" is 5. You'd add 1 (offset for header row) to that, meaning 6 is the row number of the cell you need to return data to.

By the way, how large would you imagine entire record set would be (i.e. max # of rows). And would transaction date be unique list for each individual (i.e. 1 transaction per day per individual) or could there be more than 1 per individual?

not overly large CK76... but I hadn't taken account for multiple transactions per pers on the same date ... there could be many trans ...

i'll give your suggestion a go ... thanks again

ah bakerman2 its been awhile and im still plugging away at this ...

your version as always works perfectly and as always confuses the bejaysus out of me with loops

Originally Posted by bakerman2

@ nigelog

The risk of duplicate numbers is too big to add numbers like that.
The way I solved it is to assign the row numbers of each transaction on runtime ie when loading Listbox.
Further explenation is added to code.

@ Sazza

Test it out and let us know.

had just done the same lol as a quiet day....

one last question - sorry ...

I was running through what I / we have already and have discovered a bit of an anomaly ..

if I add more than 4 transactions the 'Transactions Summary' tab goes a bit mad - row 5 gets hidden and the details start going into the same row as the previous transaction.

I've let the attached in the state im trying to explain

@bakerman
In the last file i uploaded i used the unique entry number to refresh the userform after an edit so you could see entry immediately. Can the tag be used to the same effect to rewrite and refresh listbox??