LinkBack URL
About LinkBacks
Hi,
Is there any way to fill 10 comboboxes from one source and get adjascent cells data from sheet in two textboxes.
herewith a sample to clarify what i need
thanks in advance,
Hi,
Is there any way to fill 10 comboboxes from one source and get adjascent cells data from sheet in two textboxes.
herewith a sample to clarify what i need
thanks in advance,
It is possible but the meaning is not clear to me
Kind regards
Leo
Thank you .It is exactly what I need.What want to do is to make 2 invoicing forms :
-One for simple invoice with one item and the other is for many items invoice and your help would be highly appreciated
your code worked perfectly,but want to prevent entering duplicate invoice Number in column .How would it possible?
THANK YOU IN ADVANCE
deleted post
Last edited by mikerickson; 02-08-2016 at 10:18 AM.
This can be done with a custom class.
Add a Class module and change its name to clsSomeComboBox and put this code in it.
Then put this code in the user form's code module. Note that the Art1_Change event has been removed, substituted by the ChangedComboBox_Change event.
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by mikerickson; 02-07-2016 at 07:19 PM.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Good morning,
First of all,thank you very much for your replies and suggestions
I have added a new form in which i could prevent duplicate number of invoice in column B ,but i could not do so in the other form (form5) could someone hel me to aply the same on the last one (InvN).
Herewith my file modded.
thanks in advance,
how to custom controls format to: Format(Qté1.Value, "#,##0.00")
Formatting textboxes isn't easy, but your format isn't one of the hard ones.
I'll look at that when I get off work this afternoon.
By the way, do you want to allow the user to enter negative numbers or is the entry to be either 0 or positive?
the entry SHOULD be either 0 or positive
I have tested your code ,but it gives the following error:Compile error-variable not defined.jpgCompile error-variable not defined.jpgOriginally Posted by mikerickson
This can be done with a custom class.
Add a Class module and change its name to clsSomeComboBox and put this code in it.
Then put this code in the user form's code module. Note that the Art1_Change event has been removed, substituted by the ChangedComboBox_Change event.Please Login or Register to view this content.
Please Login or Register to view this content.
That screen shot is too small for me to read.
What does the error box say and what is the line that is highlighted?
"Compile error:
Variable not defined"------------with ComboBoxes = Array(Art1, Item2, Item3, Item4, Item5, Item6, Item7, Item8, Item9, Item10) and UniteBoxes = Array(Unit1 highlighted
Those should be the names of the combo boxes and their linked text boxes.
I took them from the user form in post #3. If they have been changed in subsequent versions, they should be changed to match the new naming.
herewith my file so far and thanks in advance
Herewith the progress I have made so far
Last edited by djemy1975*; 02-10-2016 at 01:46 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks