Excel 2007 : open current cell, close window & repeat

[Camps and Vans]

Hi
This is my first time on here, I have been searching for a answer to a problem that I have but at this stage I have been unable to find one.
The situation is that a friend created some forms for me that pop up when you double click on a cell. This form has a list of items that I can put a check next to as well as putting a check next to the ones already in the cell that when you then hit enter it inserts the items checked into the cell etc. This works great, now what I want to be able to do is to create a macro or something like that I think that will :

When you double click on a cell a form comes up and automatically puts a check next to the corresponding items listed.

You then hit ‘Add Selected Items’ or enter and it sorts the items in the cell alphabetically.

So what I am looking for is something that will open the current cell (up pop’s form)
Hit Enter
Move onto the next cell down
Repeat

I have attached a test file for anybody who might be interested, basicially I need my data in a particular order in columns 9, 10, & 52:63 what it currently does is when you double click on one of these columns a form comes up listing what is in the cell and you then close it by clicking on 'add selected items' this then sorts my data into the order that I want. I had done most of these prior to working out how to use this new form, so I need to go back & sort all of the cells that I had done previously. Any help would be appreciated.

Greg

[royUK]

Thanks for taking the time to read and comply with the rule . I've changed your new title slightly.

It would be better if you attached an example workbook

[Camps and Vans]

Is what I am asking for not achievable as I have had no responses.

Thanks
Greg

[royUK]

You have code to show the form. I'm not sure what you want to do then

[Camps and Vans]

Hi Roy

Thank You for your reply.

I want to be able to do as per my original post as the data in the cells at the moment are not in any order, so instead of having to manually double click on every cell (I currently have 7,900+ lines of data with up to 13 cells on each line) I would like a macro that does this for me.

Thanks
Greg

[Camps and Vans]

Does anybody have any suggestions for me to achieve what I want to, I have been looking at every forum I can find but can't find a solution. I tried the Application.DoubleClick code but as I found out it doesn't work.
This is what I have come up with so far, but all it does is move down to the next cell and doesn't open up my form that a double click does.

Sub SortContentsofCell()
'
' Sort Cells
'
' Keyboard Shortcut:ctrl+z
'

Worksheets("Australia").Activate
Application.DoubleClick
Application.SendKeys "{ENTER}"
Application.SendKeys "{DOWN}"
Loop

End Sub

Can anybody help me please.

Greg

[royUK]

You really need to read the Forum Rules properly!!!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[Camps and Vans]

Sorry, my mistake
Code that I have done so far is :

Please Login or Register  to view this content.

Thanks
Greg