Excel Oddities

Question

Good morning.

I was doing some development today, Excel 2013 x32 fully updated, and encountered a couple issues I was hoping someone might be able to shed some light on for me (always looking to learn).

Object variable not working with controls

The following does not work and spit out an "Method or data member not found"

    Dim sht                   As Excel.Worksheet

    Set sht = ActiveWorkbook.Worksheets("Order Form")

    With sht

        .cbo_Contact.value = ""

    End With

but yet, this works fine?

    ActiveWorkbook.Worksheets("Order Form").cbo_Contact.value = ""

Cell Jumping Around Randomly

I am creating an Excel form.  So say I am in cell D9, make and entry and press enter, I get moved to K23.  Go and make an entry in I20 and press enter and I get moved to D26.  I can't seem to figure out any pattern.

Data Validation Crashing Excel

On various occasions when I make a selection in a Yes/No data validation cell Excel crashes completely?  Some times it works, the next it crashes.

Thank you for any insight.

[Moved from: Office /Excel / Other/unknown / Office 2013]

Answer 1

The simple yes/no data validation trigger a memory error and then Excel crashes.  This occurs in both Excel 2013 and 2016!

and let me be perfectly clear, this PC has plenty of available memory, HD and CPU.  so the error is obviously wrong with regards to the actual problem causing the crash.

Answer 2

Yes, I've done what I can to locate the issue, but have found absolutely nothing that could explain the behaviors.

I've done a repair not long ago (week or two ago) and it changed nothing.

I came across an MVP's website with a tool to decompile an Excel workbook which I want to try out.

Answer 3

Hello Daniel, Have you tried any troubleshooting yourself and found no results?

Have you tried a quick repair?