0

I cannot figure out a good way to allow multiple entries on the excel dropdowns I create in R using the opexlsx package.

dataValidation(wb, "Sheet 1", col = 6, rows = 1:(length(experiment_name$ExperimentName)), type = "list", value = "'Defect List_ImageLinks'!$D:$D")

Also thinking maybe I should try to use VBA. As in call the VBA code from R, which would allow multiple entries. The issue is, this would be after the entries are deleted by the above code.

Hoping to find a solution without losing data....

starja
  • 7,722
  • 1
  • 7
  • 22
Christopher Morrissey
  • 15
  • 5
  • Welcome to SO! Have a look [how to make a great MRE](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example), i.e. provide an example that can reproduce your issue. Then it's easier to help you, thanks! – starja Aug 31 '21 at 17:48

0 Answers0