Recent content by willheap

that IS exactly what I was looking for. Thank you so much Deepak.

Also, thanks Marc L for your help so far ;-)

That would work but the problem is, a lot of users of this template use the cursor keys, or simply press enter to navigate the sheet so once the userform appears they can't edit the selected cell. I can use the keydown event to continue navigating the sheet by cursor key but i can't edit cells...

I've tried to reactivate the activecell at the end of the userform initialise code and also after calling the userform from the worksheet selection change event. I don't know where else I could try the code that would be active at this time.

Good idea.. The file UF Test 1 shows a very basic version of what I use the userform for. Selecting a cell to input data shows the userform. But, the cell is no longer active until you mouse-click back on the worksheet.

I have a range of cells that require the user to input data. On selecting cell to input data, a userform shows (similar to a comments box) with all the information the user would need to populate the correct data in the cell. However, once the userform shows, the focus is set to the userform...

As the copied data now works fine, I doubt I will ever discover the source of the problem with the original DCT workbook. Just one of those things... Thanks again guys

I have now transferred all modules, userforms, worksheets and named ranges to a new workbook. I haven't got a custom UI manager in the office so I haven't transferred that yet - but it works so far with none of the problems listed above! When I get chance I will transfer the custom UI and see if...

Thanks guys, ........ do you mean interesting bad or interesting good? The original wb is considerably bigger than this and probably requires some guidance on navigating the worksheets but hopefully you can work out what is going on from the jumbled VBA. The VBA isn't finished.... as you can...

Sorry guys, I have only just noticed that I can upload a file here now.... Shows how long ago I last visited this forum.

Let's try Google Drive instead then shall we... https://drive.google.com/file/d/0B3ihjwO0b6QWSU1scU4xMHYteDQ/edit?usp=sharing I have had someone else check this link and it works OK for them.

Very strange, the link works fine when I click it! I shall redo the link. Thanks for your efforts so far SirJB7

Good point! Here is a link to a SkyDrive copy... http://sdrv.ms/1eiiHFz Thanks!

I have unusual problems with a workbook, named DCT, that I am working on from two separate computers running two different versions of MS Excel. I have tried to find a solution on line but I'm obviously not searching for the correct thing. My work computer is running 2007 while my home...

Thanks for your reply Hui, I am struggling a bit with this one. I have searched for an answer but I can't find one. So, I changed tack a bit and tried to just open a cloud file with VBA. Still no success. I can't believe nobody has asked about VBA code to open a cloud file (SkyDrive...