Hi,
The goal is to Check multiple html checkbox options in a webform.Nothing works for me, probably due to a wrong approach & syntax.
The vraiables that should to be checked are stored in 1 cell per line, and seperated with delimiter "|".
For example - Cell J(i) contains: "roleA|RoleB|RoleC" etc. Per the data stored in Cell J(i) 3 roles should be checked in the checkbox.
Each row represents 1 unique form that need to be filled, and cell "H" row i can contain even 30 options that need to be checked in the checkbox.
Obviosly it isn't working. Below is an example of an easier case where I only needed to choose between 2 options:
Hope some one has a clue how to approach this one, please let me know if you you need more data or the html elements availiable.
Thanks alot,
Nice42
The goal is to Check multiple html checkbox options in a webform.Nothing works for me, probably due to a wrong approach & syntax.
The vraiables that should to be checked are stored in 1 cell per line, and seperated with delimiter "|".
For example - Cell J(i) contains: "roleA|RoleB|RoleC" etc. Per the data stored in Cell J(i) 3 roles should be checked in the checkbox.
Code:
Doc.getElementById("Master_cphBody_divRoles").Checked = Value sht.Range("J" & i).Value
delimiter = "|"
Obviosly it isn't working. Below is an example of an easier case where I only needed to choose between 2 options:
Code:
If sht.Range("I" & i).Value = "Y" Then
Doc.getElementById("Master_cphBody_chkExemptFromResRequest").Checked = True
ElseIf sht.Range("I" & i).Value = "N" Then
Doc.getElementById("Master_cphBody_chkExemptFromResRequest").Checked = False
End If
Hope some one has a clue how to approach this one, please let me know if you you need more data or the html elements availiable.
Thanks alot,
Nice42