I have a form here that, when it's opened, we selected a property in a combobox and we click "search. "
When such property is found, it is highlighted in another color in spreadsheet and the form shows the maximum, minimum and average.
However...
1. I can't add items to combobox (there are some blanks).
2. Moreover, in the original workbook, it can not understand that
Code:
"numcol = Cells (myfinded.Row, Columns.count). End (xlToLeft). Column"
is used to take the last column of the table, though, I don't have idea why, it's ok on the sample file I did to this forum.
3. Is not calculating the maximum, minimum and average interval correctly, although the function is apparently right.
Can, please, somebody teach me how to fix these things?
What's wrong with it?
Reply With Quote
