Textbox to enter value in either format

Hi,
The format solution is the first step ...
Now, if you input price as a fraction, it is not modified ...
If you want to refine, you will need an event macro worksheet_change to detect how input is made and adapt format accordingly ...

HTH

Thank you both for your replies.

DonkeyOte... The fraction format could apply to any value at all.

JeanRage... I think what you are suggesting could be along the right lines but i don't know how to do this. Any chance you (or anybody else) could give me an example, please?

Many Thanks.

Hi,

See attached test file as a starting point ...

HTH

I'm sorry JeanRage, i'm not sure what you want me to test.

I tried typing 1.25 into D2 and was hoping it would remain in decimal format but it reverted to fractional format (?/???).

Is there something else i should be doing?

Sorry ... I misunderstood your requirement ...
See attached attempt ...

HTH

Hello Adam,

First of all, Congratulations on the time and effort you have already invested in your project ...

With no test data at all, it not is possible for me for detect potential mistakes ...
see attached test file, and let me know if it is OK or not ...

HTH

Hi Jeanrage,

The code you have added to the worksheet 'unsettled hedges' works fine when manually entering data directly into column D of this worksheet. However, the idea is to enter the data through the 'Input Form' which can be accessed through the 'Add New Hedge' Button on the summary sheet.

The problem is though, with the code added to 'unsettled hedges' worksheet, the 'enter' button on the input form no longer works. Do you understand why this no longer works?

Thanks,
Adam.

Hi Adam,

Have a go with this second attempt ...

HTH

Hi Jeanrage,

This seems to work fine on your example file but can you explain what you have changed as i need to know what to change in my original workbook.

I noticed that you changed a line in the code of the 'Enter Button' of the 'Input Form' from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

.

What i don't understand from the new line of code is how does it know which textbox value to enter into the next available row of column D?

Thanks for your advice.

Hi Adam,

I have just added this line to ensure cell is formatted as text ...

HTH

So how does it know which textbox value to enter into column D?

When i altered this line of code in my original workbook there was nothing being entered into column D of the 'Unsettled Hedges' worksheet. I'm wondering am i missing something else?

Originally Posted by JeanRage

Hi Adam,

I have just added this line to ensure cell is formatted as text ...

HTH

Added ... means that I have not removed the line

.Cells(iRow, 4).Value = Me.TextBox3.Value

Sorry Jeanrage, completely missed that!! This works fine in my original workbook now.

I may also have another issue to post on the forum about the same workbook, in the near future... so keep your eye out!!

Thank you very much for all your help! I shall now add some positive feedback to your reputation.

Glad you could fix your problem ...
Cheers