Cells.Select strange behaviour

[Kris_cs1]

Hi,
I have a userform with a listbox. When the user selects a value from the listbox, the userform closes and a cell on the spreadsheet is automatically selected.
This works as intended, but with the following problem shown in this example:

1. The currently selected cell is B3
2. The user opens the form, selects a value from the listbox.
3. The form closes and D5 is selected with VBA code.
4. The user starts typing, but the text is being written in cell B3 (the previously selected cell), and with that cell's formats.
5. When the user presses return or deselects the cell, the text correctly appears in cell D5, but still has the formats from cell B3.

I have no idea why this is happening and have tried different combinations of things e.g:
- putting 'unload me' before and after the cell selection.
- selecting the cell twice.
- enabling / disabling events before and / or after the cell selection.

I would love some ideas!

Thanks very much.

Please Login or Register  to view this content.

[Richard Buttrey]

Difficult to say without seeing the workbook.

Please upload it and in some notes explain how you use it, what values you enter/input into cells and/or listbox and what you expect to happen to any cells that are dependent on that input.

[Kris_cs1]

I've uploaded a link to the workbook here as it won't let me upload a file. It's nearly all VBA based.

To see what's happening:

1. Select cell F2.
2. Press 'Add New Student' button.
3. Type 'a' into the textbox and press the 'Find' button.
4. Double click on 'Aber, Parson' in the listbox.
5. Without clicking anything else, type something. (You should see that it looks like it is typing in cell F2)
6. Press [Return] and the text will then appear in the correct cell - I7 - but will have the same text formatting as cell F2.