Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Combo box & Autonumbering
Hi! I need help with two excel questions. I'm just starting to use excel
macros and such, and right now I need to create a combobox that will "fill as I type", so that I can input the first letters of the data and it will filter through all 2,000 to just those that start with those letter. For Example: I have my "database" on one worksheet called "data" on excel, and on another sheet I need to create these comboboxes that will use the "data" as it's database, but as I start typing--- let's say POL, it will show on a dropdown list all of my vendors who's 1st three letters are POL. Is this possible? Do I need macros for this? Could anyone help my with the VBA code I might need for this? #2) I need to create an autonumber sequence for a "receipt" type of excel document, so that everytime I print/save the document, it will add 1 to the sequence number set on a specific cell? *** Access is not allowed @ work, which is why I have to do this on Excel. Please I would appreciate any help any one can provide. Thank you!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Combo box & Autonumbering
Hello there
#1 I would rather use the validation from the data menu in Microsoft Excel which allows you to create a combo-box rather to create a combo with VBA. If you have a lot of code written which filters automatically the entries this will be very slow. Better it is to sort the data for the combo-box and if you type it will jump automatically to the letter but you still have all entries in the combo-box. Try first with the validation from the Data menu and if this is not enough please answer. #2 Private Sub Workbook_BeforePrint(Cancel As Boolean) Range("A1").Value = Range("A1").Value + 1 End Sub You can change the cell "A1" to any desired cell. Kind regards, ------------------------------------ Alex www.excelspezialist.ch ------------------------------------ "CordoK83" <u53301@uwe schrieb im Newsbeitrag news:992481aecc8ab@uwe... Hi! I need help with two excel questions. I'm just starting to use excel macros and such, and right now I need to create a combobox that will "fill as I type", so that I can input the first letters of the data and it will filter through all 2,000 to just those that start with those letter. For Example: I have my "database" on one worksheet called "data" on excel, and on another sheet I need to create these comboboxes that will use the "data" as it's database, but as I start typing--- let's say POL, it will show on a dropdown list all of my vendors who's 1st three letters are POL. Is this possible? Do I need macros for this? Could anyone help my with the VBA code I might need for this? #2) I need to create an autonumber sequence for a "receipt" type of excel document, so that everytime I print/save the document, it will add 1 to the sequence number set on a specific cell? *** Access is not allowed @ work, which is why I have to do this on Excel. Please I would appreciate any help any one can provide. Thank you!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Invoice followon autonumbering | New Users to Excel | |||
Autonumbering | Excel Worksheet Functions | |||
Autonumbering in Excel | Excel Discussion (Misc queries) | |||
autonumbering | Excel Worksheet Functions | |||
autonumbering in excel.. | Excel Programming |