Default character at beginning of cell

  • Thread starter Thread starter teamhonda97
  • Start date Start date
T

teamhonda97

Is there a way to have a character be automatically inserted into
given cell before the information that a user types in? I nee
something like a circle or square from Wingdings to be displayed at th
beginning of a group of cells almost like a bullet in Microsoft Word.
I don't want the user to have to manually enter the character befor
typing in their data. Thanks for any help
 
Honda,

If you're willing to install a macro, we can write you one that will do
that. You'll need to say which columns or rows, etc., where this is to be
done.
 
Could you use a help column? If so you could make it small to the left and
just use something like

=IF(B2="","",CHAR(13))

in A2

right align it, now left align B2

the other option would be an event macro that will add a character when you
exit the cell,
that could be bypassed when the workbook is opened

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom
 
Yeah, I have no experience at all with macros. The reasoning behin
this request is that status reports are sent by different people an
then must be consolidated into one. The current way they are doing i
is with a table structure in Word and is very nasty and time consumin
when consolidating, becuase the copied data normally does not line u
right. I thought Excel would offer significant help until i realize
that just having each person's tasks in cells down a column looke
rather jumbled in comparison to the outline type structure currentl
being used. I thought if I could add some sort of symbol beforehand
it would look more proper. In regards to what columns/cells it woul
be needed for, the document would change every week. An individual ma
have five different tasks worked on one week, but then may have eigh
the next. Would it be just a copy and paste of the macro for eac
additional cell I wanted it used by
 
Back
Top