Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Choose Invoice# fills Userform again
Patrick gave me a great code that allows me to have a user form were the
invoice# is choosen via combo box then the macro uses that invoice number to fill the text boxes. Price Boxes Purchased etc. Problem arrises because there can be more than one entry of an invoice number. eg. 1001 1001 1002 1003 1003 The only thing in the database sheet that may never have duplicates is the assigned index number. But I really need the user to have the option of choosing the invoice. The only idea I know of would be to have another column that concantenates the two (index & invoice) and have them choose that. Does anyone have any other help? Thank you The following is the code Patrick gave me. Private Sub cboInvoice_Change() RowNumber = cboInvoice.ListIndex + 2 ShowValue cboInvoice End Sub Private Sub UserForm_Initialize() With Worksheets("ProduceData") LastRow = .Range("b2").End(xlDown).Row RowNumber = cboInvoice.ListIndex + 2 End With End Sub -- Though daily learning, I LOVE EXCEL! Jennifer |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Choose Invoice# fills Userform again
Never Mind- I just concantenated them to make a unique invoice number.
Thanks.Jennifer -- Though daily learning, I LOVE EXCEL! Jennifer "Jennifer" wrote: Patrick gave me a great code that allows me to have a user form were the invoice# is choosen via combo box then the macro uses that invoice number to fill the text boxes. Price Boxes Purchased etc. Problem arrises because there can be more than one entry of an invoice number. eg. 1001 1001 1002 1003 1003 The only thing in the database sheet that may never have duplicates is the assigned index number. But I really need the user to have the option of choosing the invoice. The only idea I know of would be to have another column that concantenates the two (index & invoice) and have them choose that. Does anyone have any other help? Thank you The following is the code Patrick gave me. Private Sub cboInvoice_Change() RowNumber = cboInvoice.ListIndex + 2 ShowValue cboInvoice End Sub Private Sub UserForm_Initialize() With Worksheets("ProduceData") LastRow = .Range("b2").End(xlDown).Row RowNumber = cboInvoice.ListIndex + 2 End With End Sub -- Though daily learning, I LOVE EXCEL! Jennifer |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Choose Invoice# fills Userform again
But the code Patrick gave you did not depend on what Invoice number was
chosen. (It would be unclear how the user would differentiate however). -- Regards, Tom Ogilvy "Jennifer" wrote in message ... Never Mind- I just concantenated them to make a unique invoice number. Thanks.Jennifer -- Though daily learning, I LOVE EXCEL! Jennifer "Jennifer" wrote: Patrick gave me a great code that allows me to have a user form were the invoice# is choosen via combo box then the macro uses that invoice number to fill the text boxes. Price Boxes Purchased etc. Problem arrises because there can be more than one entry of an invoice number. eg. 1001 1001 1002 1003 1003 The only thing in the database sheet that may never have duplicates is the assigned index number. But I really need the user to have the option of choosing the invoice. The only idea I know of would be to have another column that concantenates the two (index & invoice) and have them choose that. Does anyone have any other help? Thank you The following is the code Patrick gave me. Private Sub cboInvoice_Change() RowNumber = cboInvoice.ListIndex + 2 ShowValue cboInvoice End Sub Private Sub UserForm_Initialize() With Worksheets("ProduceData") LastRow = .Range("b2").End(xlDown).Row RowNumber = cboInvoice.ListIndex + 2 End With End Sub -- Though daily learning, I LOVE EXCEL! Jennifer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
missing invoice toolbar when save customised invoice | New Users to Excel | |||
Invoice templet Excel97 to 2003 invoice toolbar missing | Excel Discussion (Misc queries) | |||
Choose Invoice# fills userform | Excel Programming | |||
How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) | |||
Userform Combobox to choose date | Excel Programming |