Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. friedmar

    Input changes in multicol userform listbox possible?

    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
  2. friedmar

    Input changes in multicol userform listbox possible?

    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...
  3. friedmar

    How to change R1C1 notat. to cell notat. for iterative sumproducts?

    Hi Skip, the macro now works perfectly (see last and successful version below), thanks a lot . Now it is better to understand what is going on in your modified script. Alway the values from sheet("UI") have been B2 up to B6 for ALL cases. Therefore I changed only the iCol values to...
  4. friedmar

    How to change R1C1 notat. to cell notat. for iterative sumproducts?

    Hi Skip, I had some days of vacation, so there was a delay to thank you. Keep in mind, I am a newbie in VBA. So there are again questions to your solution. I changed your code a little bit, because your code snippet had to be changed a little bit. I have two sheets in my workbook UI and DOSES...
  5. friedmar

    How to change R1C1 notat. to cell notat. for iterative sumproducts?

    Hi, I have some experience in Excel but I am a beginner in VBA. So, I hope you will not be angry that I have the following problem. Suppose you have a matrix which is stored in sheet "UI" line no.2 nuklid1 0 line no.3 nuklid2 2,00E10 line no.4 nuklid3 3,00E10 line no.5 nuklid4 0...

Part and Inventory Search

Back
Top