|I understand that you are having problems with the code I offered.|
As I re-read some of your earlier posts, there appears to be some inconsistencies that I need clarification on.
In Response #2 you said:
E:1 has a 1 in the cell by itself
F:1 has a 2 in the cell by itself
G:1 has a 3 in the cell by itself
H:1 has a 4 in the cell by itself
I:1 has a 5 in the cell by itself
In other words, I assume it looks like this:
E F G H I
1 1 2 3 4 5
Also in Response #2, you said:
So, under E, F, G, H and I, will be the same 1-5 cells to pick from. E will only have the number 1 in the column to choose from, F will only have the number 2 to choose...etc.
However, in Response #4 I now see this:
...only 5 particular columns. In particular: (E, G, I, K & M)
What happened to wanting the numbers under E, F, G, H and I as asked for in Response #2?
The code I wrote was based on the columns you asked for in Response #2 (E:I)and the Rows you used in Response #4.
It will place the numbers from E1:I1 into Columns E:I, when you select (no need to double click) a cell in the rows you asked for, specifically rows 20, 30, 39, 48, 57, 66, 75, 84, 93 & 102. Nothing will happen if you select any other cell in the worksheet. Only Column E:I and only in the rows specified.
In other words, if you select E20 a 1 will appear. If you select G39 a 3 will appear. In addition, if you select a cell in Ex:Ix that already has a number in it, the original number will be deleted and the corresponding number for the currently selected cell will appear. That gives the user the ability to change their mind or make a correction. Once again, these numbers will only appear in the specific rows mentioned.
So, perhaps we have one or more of these 3 issues:
1 - You have not properly placed the code I offered into the VBA editor.
2 - You have modified the code such that it doesn't work as originally intended.
3 - The code was written for the columns you asked for in Response #2, but you really want it to work on the columns you used in Response #4.
If you'll clarify which of these you think is the problem we can take it from there.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.