Enter form details into different sheets on checkbox value

Hi Guys,

I've got one more problem to solve with my current project. An example of the workbook is attached.

What i want to do is change the code on my 'enter button' of the 'input form' which can be shown by clicking the 'Add New Hedge' button on the summary sheet.

The change i want to make is when the user clicks 'enter', if the 'settle now' checkbox is false to add the details of the form to the unsettled hedges form as it currently does.

If the 'settle now' checkbox value is true then i want the form details to be added to the next available row on 'settled hedges' worksheet, in the same way it currently does for adding into the next available row of the 'unsettled hedges' sheet. Also here, i would want the value of the 'returns' textbox added to be added into column L rather than the text "unsettled". This would also mean when the 'settle now' checkbox is true that the 'returns' textbox needs to have a value before adding any details.

Thanks,
Adam.

looking at the code that you have so far im sure you will be able to figure things out from here.

One approach to assinging the values to diffrent sheets based on the checkbox.

Please Login or Register  to view this content.

nice bit of code you had here well done.

cheers/

Thanks for that D_Rennie, still got a couple of issues though, hopefully someone can help.

First of all, the code you written had the details going into "Unsettled Hedges" when the checkbox was true and going into "Settled Hedges" when the checkbox was false and it should have been the opposite way around. This was easy enough to swap around but just thought i'd clear that up in case i was unclear in the first place.

One other issue that i am unsure of how to rectify is when the 'settle now' checkbox is unticked the 'returns' textbox does not need a value but currently the code at the top of the procedure is stopping the details from being entered.

Attached is the latest version of the workbook.

I'd very much appreciate any help.

Sorry Jeanrage, the attachment i posted had the code missing from the top of the procedure which checks the form for missing details. (no wonder i wasn't getting any replies!!).

Please Login or Register  to view this content.

I have re-attached file with correct code this time.

What i want is when the 'settle now' checkbox is ticked the form needs to check if the 'returns' textbox' has a value but when unticked it doesn't.

I've sorted the problem with checking the correct form controls whether the checkbox is ticked/unticked now. It might not be the best way of writing the code but it does the job so i am happy with it.

I still have the problem with the date format though. If i click 'Add New Hedge' button and then then click the calendar icon to open the calendar form and then choose a date. The format shows correctly in the textbox (dd/mm/yyyy) on the input form but when i fill in all the other details and click the enter buttton then the date is entered into column A of 'unsettled hedges' / 'settled hedges' and the session log sheet in US stlye (mm/dd/yyyy).

Can someone tell me what i need to change in my code to keep the european fomat when entered into the cells of the worksheets.

Attached is my latest version for your reference.

Thank You,
Adam.

Hello adam

sorry for the late reply.

for the number formatting does this help.

Please Login or Register  to view this content.

looks like you got everythink sorted. ill look into the file a little ater tonight or tomrow as the worksheet code i gave is messy.

cheers

Ive made some changes to the code that seam to fix the problem.(though it is getting late and i could be seeing things. )

Please Login or Register  to view this content.

cheers

Actually swapout

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

that looks better now the fog has cleared.
cheers