am working on creating a user form to store data in excel & update record, I have 3 requirement to complete my user form design.
1. How can i create a unique reference number (preferable starting with first 3 character in some textbox followed by incremental number) for each of the record which is getting saved in a excel using userform.
2. Also would like to know how can i retrieve a record and update record in excel using userform.(Preferable by using one or two value)
In case search result have more then one record to search result option to select required record.
3. I will also be adding 3 drop down box(Segment, Product & Sub Product) in user form. Values which are available under Product should depend on what user have selected Value under Segment & Values which are available under Sub-Product should depend on what user have selected Value under Product
Sample structure of Database i have created in excel
Segment Product Sub-Product
SEG-1 Prod-1 SubP_1
SEG-1 Prod-1 SubP_2
SEG-2 Prod_2 SubP_3
SEG-2 Prod_2 SubP_4
Thanks in Advance
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar