Add comment to cell

[arina]

Is there a way to add comment to a cell in excel? I already detected the row and column but don’t know how to add comment. I read through smartsheet activities but it’s a bit complicated. Is there an Invoke Code or Invoke VBA ways to add comment?

[fernando_zuluaga]

Hey

for that you can use the balareva actitity

UiPathGo - BalaReva Excel Activities

Hello Friends, I have successfully uploaded the BalaReva XL Activities in UiPath Go. This package contains 36 custom activities. It is related to the Workbook, worksheet and sheet data. It helps and simplifies more processes into the excel file. All components can be configured very user friendly. https://go.uipath.com/component/balareva-xl-activities This package is having the below activities. Pie Chart - Using these activities you can able to generate the Pie Chart Column Chart - Using…

Regards

[arina]

it only works for windows legacy. i use windows.

[fernando_zuluaga]

Hey

Check this example
ExcelVBA.zip (9.5 KB)

Basically create a text file and add the following code

Sub AddComment()
    Dim cell As Range
    Set cell = Worksheets("Sheet1").Range("A1")
    cell.AddComment "This would be your comment"
End Sub

Then just do a invoke VBA activity

call the txt file with the code and the Sub name that would be AddComment

hope this helps

Regards

[arina]

How can I pass range to VBA? I tried and unable to pass. I have two variables: int_idx and str_Column. For example, int_idx is 25 and str_Column is “C”.

[fernando_zuluaga]

check the following example
ExcelVBA.zip (9.5 KB)

Regards

[arina]

Is this correct file as it’s the same as before?

[fernando_zuluaga]

i made some changes to the init file, so it will replace the data and then create another file with the correct data that will execute the vba

[arina]

Would mind explaining which part that affected by changes? As I see it the same as before.

[fernando_zuluaga]

oh sorry, i updated the wrong project, here you go
ExcelVBA.zip (10.2 KB)