FergusonRK
New Member
- Joined
- Jul 26, 2007
- Messages
- 14
Hi Folks,
I have a spread sheet that was working fine (thanks to some help from shg and Teeroy) but that now shows an anomaly. I have already posted the code under the thread "saveAs not actually saving file"
The VBA code within the changeevent move focus from cell to cell in a way that is not conventional. The spreadsheet captures hours worked for four tasks or categories for each doay of the week. So, once the user types in a date in cell K1, the code redirects focus to D6 so the user can enter hours for the first task for Monday. When the user services the last cell for Monday, "D9", the code redirects focus to C12 so the user can enter a descrition of the work the did on Monday. When they finish the description, and "Tab" out of the cell, the code redirects focus to "E6" so the user can enter hours for Tuesday, and so on. This worked find except the file did not save. "shg" kindly pointed out the missing code to fix that.
But now, after entering the hours and description for Monday, and tabbing out of C12, focus jumps to cell H7 for no reason that I can discern. Thought leadership (in my little community of fellow Excel padawans) is that the problem stems from merged cells. C12 through F12 are merged to set up a bounded area into which the user enters the descripton of work performed for Monday. C13:F13, C14:F14, C15:F15, C16:F16, C17:F17, and C18:F18 are merged to set up the same sort of area for a description of work performed for Tues, Wed, Thur, Fri, Sat, and Sunday. H12:K12 sets up the same sort of container into which the user enters a description of activity planned for the following week.
If it is in fact the merged files causing the intermittent issue, is there a way to modify the change event to look at the range of cells that make up that input area and redirect focus based on a change within that range?
I have a spread sheet that was working fine (thanks to some help from shg and Teeroy) but that now shows an anomaly. I have already posted the code under the thread "saveAs not actually saving file"
The VBA code within the changeevent move focus from cell to cell in a way that is not conventional. The spreadsheet captures hours worked for four tasks or categories for each doay of the week. So, once the user types in a date in cell K1, the code redirects focus to D6 so the user can enter hours for the first task for Monday. When the user services the last cell for Monday, "D9", the code redirects focus to C12 so the user can enter a descrition of the work the did on Monday. When they finish the description, and "Tab" out of the cell, the code redirects focus to "E6" so the user can enter hours for Tuesday, and so on. This worked find except the file did not save. "shg" kindly pointed out the missing code to fix that.
But now, after entering the hours and description for Monday, and tabbing out of C12, focus jumps to cell H7 for no reason that I can discern. Thought leadership (in my little community of fellow Excel padawans) is that the problem stems from merged cells. C12 through F12 are merged to set up a bounded area into which the user enters the descripton of work performed for Monday. C13:F13, C14:F14, C15:F15, C16:F16, C17:F17, and C18:F18 are merged to set up the same sort of area for a description of work performed for Tues, Wed, Thur, Fri, Sat, and Sunday. H12:K12 sets up the same sort of container into which the user enters a description of activity planned for the following week.
If it is in fact the merged files causing the intermittent issue, is there a way to modify the change event to look at the range of cells that make up that input area and redirect focus based on a change within that range?
