Excel User Form VBA

[DIlani]

I need to create a data base for my bill entries.I have created my sample database in "Detail Bill" sheet and user form o1 which needs the data entry.I have already renamed the text boxes and combo boxes too. I need the VBA code to create my data base.can anyone help me on this.My sample file is attached as Part 01 and Part 02. Pic are also attached.

Thank You,


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[DIlani]

I have attached the original file here as part 01 & 02.Please ignore the previous files

 

[Belleke]

I don't mind helping you but I can't open your example(s)

 

[DIlani]

It is a rar file "compreessed file".you need to have Winrar for opening

 

[Belleke]

I know it is a rar file, but your file is no good.

 

[DIlani]

Today I downloaded and extracted the file. It was properly opened. I am sorry I dont understand what you meant by " file is not good". Could you please explain son that I can make changes.
Thank you,

 

[Belleke]

This is what I get.

 

[DIlani]

I am really sorry for the inconvenience. How can I upload the originalbum file without compressing. It iseems nearly 11 MBA.
Thank you.

 

[Belleke]

You can use something like Wetransfer
https://wetransfer.com/
Upload your file and then post the link here.
In the button with the 3 dots check send as link.

 

[Marc L]

Hi !

Or : as WinRar can save to a zip format …​

 

[DIlani]

I have changed my conceptual design from the previously send files. Here in this new concept already the database is same and the user form has been changed. here in this concept I have to tick whatever the rice variety in my bill and all the varieties are 1 Kg packs except Porridge. Porridge pack is 150 g. Shops list is listed under the "drop down list" sheet.Prices are also listed under the "drop down list" sheet. I need to get the VBA Code for this programme.
you can download the file from below link.

https://we.tl/NfKFwedmAq

Thank You

 

[Belleke]

Something like this?
Start with 01 then 02 ...
https://we.tl/5FornaQAHh

 

[DIlani]

ok. Thank You Very Much.

 

[NARAYANK991]

Hi ,

Your file was 11 MB in size only because the last used cell in the tab named Detail Bill was I1048576 !

The entire worksheet was empty except for the header row in cells A2:H2.

Deleting the rows from 3 downwards , and saving the workbook resulted in the size reducing to 29 KB !

Narayan

 

[DIlani]

ok.Thank You.

 

[DIlani]

Something like this?
Start with 01 then 02 ...
https://we.tl/5FornaQAHh

Hi Belleke,

Can you help me to create my 02 nd project.I am working with 01 one it is working fine.