Forum Discussion

BernardFanthom's avatar
BernardFanthom
Contributor
10 years ago

Putting a variable value into an edit control

Hi,   I have been putting text into an edit control using the Key and SetText operators. My next aim is to put in variable data (from a variables excel sheet). Application written in VB6. How do I ...
  • BernardFanthom's avatar
    BernardFanthom
    10 years ago

    Thanks all for your help. Seem to have cracked it. Between redundant code failing (unwanted recording stuff) and indentation not done properly the script was failing. Now sorted.

  • BernardFanthom's avatar
    BernardFanthom
    Contributor
    10 years ago

    Hi,

     

    Sorry the link does not provide the ansert I am looking for. I am trying to enter test in a VB6 combobox.

     

    If I use Edit with Operation SetText and the Value "B[Tab]" ot works fine and the combbox populated with th entry which starts with a B.

     

    However if I try to variableise the B, so my value reads ExcelFile.Variables.VarLoop1("Replacement_Value")[Tab], it does NOT work.

     

    Should I use a different command?

    • prasad_kumar_s's avatar
      prasad_kumar_s
      Contributor
      10 years ago

      try ExcelFile.Variables.VarLoop1("Replacement_Value")+[Tab],

      If + doesnt work then you can use &. Basically you need to concatenate the values

       

      • BernardFanthom's avatar
        BernardFanthom
        Contributor
        10 years ago

        Thanks all for your help. Seem to have cracked it. Between redundant code failing (unwanted recording stuff) and indentation not done properly the script was failing. Now sorted.