Hello.
2 question with coding textbox results and removing empty "blank" cells from a range for the use in a combobox.
Question 1,
In the usecal.form, frame 2 "aera calculation" There are 4 text boxes num1, num2, num3, sum.
The code currenty there is only good for a M3 calculation.
Though what im aming for is if num1 & num2 show a value the a M2 is entered into sum, Plus the use of current code.
Question 2,
On the 3 userforms there are combobox's "product" & "supplier" they refer to another document for their list items. Though the problem is there are empty cells withen the cell range that i wish to kepp. and if i use this as the ListItems range the empty cells are inserted into the combobox.
Im not realy sure if im aproching this the right way or not,
Any idars for a new approach for when dealing with suppliers and products trying to use them like i am on the 3 forms. they will eventually end up with a lot of data that will be used in diffrent ways.
For instance on a pictular product will need to have the unit price, unit breakup price "M, M2, M3" how much product would be needed to install per M2, M3 ect. Stock, Shipping Sizes and more
apologize about post name
Bookmarks