Search results

Hi folks! I have a question about the Form_Error sub... I need to do some error handling and this sub just doesnt work.... It never ever pass inside even when some errors are thrown... Anyone has a clue why? :banghead: Private Sub Form_Error(DataErr As Integer, Response As Integer)...

Hi again, I found we can set the viewable range in the options of the spreadsheet control. That is very nice but... can we do it using VBA? I can't find a damn method for this. All I'm trying to do is change the range dynamicly based on my needs. Then this is my "more advice than question"...

Hi folks, Having some troubles with ActiveX controls. I tried with many of them as the "Spreadsheet" or the "Listview".. I add them to a form, go into VBA on a "form_load()" sub and try to use them. Problem is when I type their name and then use the "." to get their properties, I don't have...