Automatic Table Sort (vba code)

[dellmech]

Hi, I have something that seems it would be easy that I can't figure out and need some help.

I have a Table that looks like this:
A
1| COLORS
2| Blue
3| Orange
4| Red
Yellow

I want the user to be able to enter Green below Yellow and the table automatically sorts the data when the user hits enter. It is important that this be a Table so I'm looking for the VBA code to point out the table (not certain cells.

 

[igold]

I can't really figure out what you are asking here. However, this is a nice guide to working with tables...

Excel Tables — The Spreadsheet Guru

 

[dellmech]

I think my “visual” was messed up. To summarize, I have a table that has data in it and when someone adds data to the table, I want the entire table to automatically put all the data in alphabetical order.

Example: if my table heading is “Colors” in cell (A1) and I have blue in (A2), orange in (A3)....when I type in “green” in (A4), I want the table to automatically be put in alphabetical order when I hit enter.

So (A2) would say blue, (A3) would say green and ((A4) would say orange