Input changes in multicol userform listbox possible?

[friedmar]

As a beginner in Excel VBA I want to create a
USERFORM with a multicolumn listbox.

Two things should be possible:

1)

It should be possible to create a userform
to DO CHANGES in the numbers IN col2 and WRITE
THE CHANGES BACK to the same position;

no resetting to default values in col2 after
closing the excel sheet. It means if I start
my userform again, I should have the
"this was the latest changed" situation in
my sheet and userform when I start the userform
again.

the content in col2 should be NUMBERS;

the values from the second to the last row in
col2 should be in SCIENTIFIC NUMBER FORM
(i.e. if someone puts in 2e+12 it should
be written back into the sheet as 2.00E+12;


2)

It should NOT be possible to do any changes in
col1; i.e.:col1 should be locked in some way.


As an example I give you the basic information
in my table1 sheet

col1 col2
------------------------
row1 HEADINGA HEADINGB
row2:factor 3,5
row3:nuclid1 0
row4:nuclid2 2,00E+10
row5:nuclid3 3,00E+10
row6:nuclid4 0
row7:nuclid5 5,00E+10

So, I want to leave unchanged(and protect) the descriptionial text in col1, but I want for example to modify the values (numbers) in col2 for example cell(3,2) from 0 1,70e+9 and write this NUMBER back to the same cell(3,2) as 1,70E+9


3)

Is it possible for you to give a step for step advice
how to manage this userform task ?


Any help is appreciated.

Friedmar

 

[friedmar]

Hi,

sorry for giving the wrong keyword:

I want to use scrollable comboboxes, edit something in
column 2 and I want to write it back in column 2 at the
same position.

Sorry for any inconvenience.
Best regards
FRiedmar