Run vba code, try to type on active sheet, it puts on different sheet

**cheeze83** · 05-20-2014, 04:21 PM

Hi all

I have created the attached document, and the problem I am having is when the New QPR Form button is pressed - after the job information is input, it opens a tab for the user to input data.

However, if you try to type, it inputs the data into the Tools tab, rather than the form - the only way round this is to click on tools, then on New QPR tab and it works fine.

So, I try to allow for this in the code, but it hasn't worked - does anyone know how to solve this?OA Planner.xlsm

**Jack7774** · 05-20-2014, 04:38 PM

I think I deleted the line of code you were having trouble with try again.

Just in case it was the sheets("tools").select line in this section below

Please Login or Register  to view this content.

**cheeze83** · 05-20-2014, 05:08 PM

Thanks for looking Jesse - unfortunately still the same problem though - also just realised I should have specified - I am using Excel 2013 - this was originally written in 2007 (and worked fine) - but I then found out it needed to be in 2013 - I need to make some changes to conditional formatting, but all the other code works fine, expect the DQPRFORM sub, which has the issue with writing to the tools tab when you try and fill in the Y/N boxes

**cheeze83** · 05-22-2014, 09:51 AM

For any of those having a similar problem, I have managed to fix this.

What the form was doing was calling a userform for the job number, then openeing the orm to complete, then after pressing submit it would create it for that job.

Now what it is doing, is doing it the other way round - opens the blank form first, then calls the userform - this way round, works perfectly. Not sure why, but hey ho!