Posts by jhazziejhazz

Quote from royUK

I'll take a look later.

The file uploading issue should be fixed now

Thank you so much Roy.

You're the best.

Quote from royUK

Why are you using an xltm file?

Hi Roy,

I must've saved it in xltm.

My original file is .xlsm.

What should I do then.

I am so sorry for the ignorance, I did not have proper education regarding this, I am only learning this thru various youtube videos and help from other excel masters like you guys.

Thanks,

Sorry about that, Already granted the access.

Thanks again.

You’re the best.

Quote from royUK

I've reported the issue if you want to try later.

In this instance you can use a link and I'll look at it.

Thank you so much Roy.

Thanks for being so accommodating.

You're awesome

Here's my project

Google Drive stellt sich vor – Alle Ihre Dateien an einem Ort

I tried again, but still unable to upload it. The file is more than to 2mb.

Thanks anyway,

Thank you for your help.

Quote from royUK

Try zipping it.

I tried Roy, but still its more than 2MB.

I guess I cant do anything about it.

Thank you tho for the quick response, and again I'm sorry for breaking the rule.

More power to you all.

Y'all are so amazing.

Quote from royUK

That's much easier to do with formulas on a worksheet.

Attach the example to the Forum post. The reson is explained in the Forum Rules which you agreed to and need to read.

I'm so sorry for breaking the rules Roy.

I totally forgot about links and cloud drives. My file is too large, please let me know how can I upload it. Thank you,

Again my apology for breaking the rules.

Dear Masters,

I have this inventory tracker excel file, that has use form for my search function (see attached image)

I have a combo box for search option, the result will display in 2 separate listbox one is the AVAILABLE STOCK and the other one is SEARCH RESULT - PRODUCT MOVEMENT.

I have this 3rd list box, in which I wanted to have the values when I click 1 of the result from listbox in Search Result - Product Movement. Values for these list box will come a different sheet (RRBS_List)

Example, When I search for a particular Part Number, results on Search Result - Product Movement will display, and when I click one of the result, the values will populates the third listbox.

I hope I made my explanation clear.

Thanks in advance for those who will take time to answer this queries.

I have attached my sample project. This has been a work in progress.

Quote from royUK

Actually, you don't need Format. Use the TextBox_Change event instead of Exit

Hi again Roy,

Its awesome.

Thank you so much. You've been a lot of help for me in this project.

You're such an angel. Thank you so much.

Jhazzie

Quote from Ingo_Ingo

Hi,

for this:

[Blocked Image: https://www.ozgrid.com/forum/core/index.php?attachment/1231707-7-png/&thumbnail=1]

In Private Sub lstProformaDisplay_DblClick(ByVal Cancel As MSForms.ReturnBoolean)

replace:

Me.txtDate.Value = Me.lstProformaDisplay.List(Me.lstProformaDisplay.ListIndex, 2)

with:

Me.txtDate.Value = Format(Me.lstProformaDisplay.List(Me.lstProformaDisplay.ListIndex, 2), "dd-mmm-yyyy")

Display More

Hello there,

Its perfect.

Thank you so much.

Jhazzie

Hi Roy,

I did try, But it doesn't work for me. I wonder why.

Hi Roy,

The codes you have provided perfectly works for me. And I am so thankful for that.

However my problem actually is, whenever I pick a transaction on my listbox (say I want to edit something), like the one highlighted, the date is 05-April-21, but what is displayed on the textbox date is numbers 44291. Is there a way for it to display also as date?

Hi Roy,

The UserForm I am referring to is the frmProfoma.

I have inserted the Zipped file for your reference.

Thanks for your help.

Jhazzie

Hi Roy,

Thanks for the quick reply as always.

Here's the link to google drive, as I am having a hard time uploading the file as attachment here.

https://drive.google.com/file/…s3vZmWKI/view?usp=sharing

Regards,

Jhazz

how can I fix this, my date always shows as numbers.

Please help.

Thank you.

Quote from JCabral

This solution solves one problem for you, but adds another one, that is, the date problem I think is solved, but by this method the column headers disappear, it is an EXCEL / VBA fault.

The solution is to put a label, for the headers, otherwise the solution is just as RoyUK says.

Hi JCabral,

Thanks for the help, it's working,

I can just add labels since the headers were gone.

Thanks again,

Jhazzie

Quote from royUK

I've added code to sort the IN_OUT sheet to show the latest record first.

I can't really understand what you are doing, there seems way too many operations in your userform than necessary.

Hi Roy,

Thank you so much for your help.

I know this is so chaotic. I just don't want to delete some codes, I am just afraid something might not work if I delete some operations in my userform.

This a work in progress and I am hoping to improve this project as I go along.

Thank you so much for your patience and for your help.

Jhazzie

Quote from royUK

Pleased to help.

Post back if you need further help.

Visit my web site, http://www.excel-it.com, for more examples and some helpful articles.

Thanks again Roy,

Also can you help me again.

On my HOME form, I want my Listbox to display the newest data I entered on top.

(please see attached file)

Lik

Quote from royUK

Try this

It's perfect. Thank you so much Roy, you are such an angel.

Jhazzie

Quote from royUK

I've worked on this previously.

I would suggest that you replace the TextBox with a ComboBox so that the the user cannot enter parts that do not exist.

Hi Roy,

Yes you did, and it was awesome.

As regards to the ComboBox, It will be perfect if I can make such, however, I have really no idea how to formulate it.

Hoping to get some insight from you,

Thank you so much.

Jhazzie