Search results

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...

Is it possible to create a reference to a cell in a workbook saved on SkyDrive without the workbook being opened? If so, how?

Thank you all!! Your response is very much appreciated. I will check your code out today and let you know how it goes. (It looks like I need to get to grips with the requirement for .Address)

The macro still fails at: Names.Add Name:="HRRange", RefersTo:=Newrange but why??

Hello Narayan, Again, you have come to my rescue! I must owe you several beers by now! However, running your code still gives the same error in the same place. Any other ideas? I am running this code from a module but I can't see why that would cause the problem. Just a query; how does...

Hello All, I have written a macro to (try to) create a non-contiguous named range in a worksheet containing 10,000+ lines of data. Each of the 268 non-contiguous ranges is in column C and is 10 rows deep by 1 column wide starting at each cell containing "Process Components". The main part...

Actually, strike that... it doesn't work in the module anymore! What on earth is going on there? Fortunately, it DOES work in the sheet.

Thanks a lot Narayan, that's fantastic! It didn't work in the original module so I copied the exact same code to a sheet and it worked! The strange thing is, without changing any code at all it now works back in the module too?!?! I have no idea what was going on there but it works now, yipee...

Thanks Narayan, Unfortunately, it still doesn't work on my computer :( Just to check that I haven't lost my marbles; did you run this in a module? I have tested the part of the code that would delete the named ranges by changing the line below to text i.e. 'wb.Names.Add Name:=ws3.Cells(1...

Hello again NARAYANK991, I deleted wb in an attempt to find my error and forgot to put it all back before posting the message. It's on the line: wb.Names.Add Name:=ws3.Cells(1, Col), RefersTo:=ws3.Range(Cells(2, Col), Cells(Row, Col)) My macro includes the following code to go with wb...

Thanks bobhc, that is useful to know. Unfortunately, it doesn't solve my VBA problem though. I need this process automated as it must be updated every time the workbook is opened.