VBA UserForm to return a value from a spreadsheet

[Newport Count]

Hi,

i have created a userform in excel that once opened allows users to fill in information that gets logged in a spreadsheet

i require a pop-up box to appear once all the data has been completed on the form and sent/populated in the spreadsheet

i require this pop-up box to display the value of a cell in the spreadsheet that gets populated once the form has been completed - so this particular cell is a formula that is based on other fields that have been sent via the form

form textbox 1: London - sent to cell A1

Column B is a numbered list - B1=1, B2=2, B3=3, B999 = 999 etc

Column C is a formula based on Column A (first 3 letters) & B.....so C1 = Lon1

can "Lon1" be displayed in the pop-up box once the form has been sent?


another example:

form textbox 1: Birmingham - sent to cell A33

C33 = Bir33

Many thanks!

[StephenR]

I suggest you attach a sample workbook to illustrate what you want doing.

[Newport Count]

sorry i tried to make it as simple as possible - i cant really attach the sheet as it contains confidential information

the userform contains a few different fields to fill in (checkboxes, radio button, drop downs, text etc) when OK is clicked all of the information gets sent to a spreadsheet to store all of the info - a new line for each entry

i am trying to work out if it is possible to display a value from a cell in that spreadsheet in a pop-up box once the form has been sent - this value is based on other cells that have been entered into the spreadsheet via the form

[StephenR]

Just use representative dummy data.

Do you mean like this?

Please Login or Register  to view this content.