use form

Dear all, food year first. I have an issue for the following code. As per photo 1.2 i have create an useform where upload the % of a portfolio allocation (from 0,1 to 1%) for a max of 10 stock and in case put 0 as number if that stock doesn'twant be choosen from the user. The problem is that i...

If I select a value from a drop-down list in the userform (the values come from a spreadsheet), how can I know if the value is for example highlighted red or green in the spreadsheet. So if it's green I send an email with contents saying 'green' but if it's red I send an email with the body...

I have a spreadsheet that I use for merging for details to word forms on a regular basis. My problem is that a colleague often opens the spreadsheet to obtain data and this then stops me from either using the spreadsheet to merge or from entering new data (using a user form). Is there...