Cell in Excel spreadsheet will not accept entry of specific data v

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet where certain cells will not accept my name, but will
allow almost anything else. I have other cells that have silmilar problems
with other data. These cells did have validations in place which were
removed. But I did a Clear ALL on the cells in question and even used the
validation command to "accept any value" but nothing I try works. Anyone
have any suggestions on how to clear this problem?
 
Are there macros in this workbook including under that particular worksheet
or workbook on the VBA side of Excel or a macro sheet?
 
Yes. The spreadsheet has a couple of forms and a macro module with about 30
custom subroutines and functions. There are on sheet validations set. I
don't do any validation from within VBA. I prefer the use of listboxes
instead. However, both on sheet validations and VBA based macros use the
same "named" cell ranges which contain the content of the picklists used.
 
From the spreadsheet side, have you tried temporarily disabling the
execution of macros by bringing up the Visual Basic Editor toolbar and click
on the design button so as it's pressed down, then try to enter your name in
those particular cells? By doing this, we can with a high probability
narrow it down to either just the VBA side or just the spreadsheet side.

The only other thing that I could possibly think of is that if you have a
range name and a public function by the same name, that could potentially
create a problem.
 
Back
Top