unable to popup excel cell menu by shift-f10
hello,

i am trying to popup the contextual menu for an excel 2010 cell. this can be done by the shortcut shift+f10. i am not able to perform that from the robot. my activities’ sequence is:

select range -> coordinates of cell i am interested in (eg a1:a1)

type into -> key sequence “[k(shift)][k(f…
hi [@prepetti](/u/prepetti),

try the send hotkey . it showing the context menu,

[image]

file : [excel.zip](https://aws1.discourse-cdn.com/uipath/original/3x/6/b/6b8e341a2c0952e41bb5c6738e513b77072e2268.zip) (1.7 kb)

regards

balamurugan.
welcome to mrexcel!

it actually works for me (see below). this appears to be a kind of rounding error. the way excel stores numbers causes some issues when you have decimals. it is a bit rare when comparing a cell to itself, but it can happen. you can try to use sumproduct instead, see column h.

efgh1valuescountifranksumproduct248737.76222336113.11333454287.76111f2:f4f2=countif($e$2:$e$4,">"&e2)+1g2:g4g2=rank.eq(e2,$e$2:$e$4)h2:h4h2=sumproduct(--(round($e$2:$e$4,2)>round(e2,2)))+1 try setting the format for the udcodes\_longdesc in your baq to x - instead of x(xxx). then your dropdown will follow the width of your control. i would do it like this:

https://www.advanced-excel.com/columns-to-rows.html okay, so here’s what i created to “fix” the readability.

in the window paint event add this code for each control you wish to see better.

if color.isdarkmode and lightskin then

var r as double = popupmenu1.height-20 // just in case the height got larger than 20 (macos default)

g.drawingcolor =… Hi Djhenry,
  

  
When you right-click a sheets tab, you can select all sheets. When you have done that, you can insert a row and enter all the information and all sheets wil contain that information.
  

  
Best regards,
  
Trowa > 
> i want to create ap application which generates popup alerts at the day of event ocurs as well as a day before the event will occur in a specific time interval as well.. events are stored in database and they are all date fields .. so i want to link those fields to create popups .. help me .
> 
> 
> 


In order to help you, you must first provide us with what you have achieved. We do not write code for you, simply correct and enlighten on mistakes. yes for current region you can use a range 
  
something like this 
  

  

  

```
With Worksheets("sheet1")
.range("A1:e10").copy
```

  

  
the dot before "range" is important.
  

  
it will copy only from A1 to E10. modify to suit you here is an example notebook

<https://gist.github.com/volkerh/465925d24accc940f7a0a0b1f5f40f7a#file-map_array_example-ipynb>

map\_array\_example.ipynb

{

"cells": [

{

"cell\_type": "code",

"execution\_count": 1,

"id": "satellite-momentum",

"metadata": {},

"outputs": [],

"source… i had to actually connect to the team viewer from remote to get this popup. can you please fix the documentation to reflect this step please?

https://community.teamviewer.com/t5/knowledge-base/how-to-control-a-mac-running-macos-10-14-or-higher/ta-p/44699#toc-hid--**please do not post teamviewer ids** for example, you can disable right click on images at your page:

```

$(document).ready(function() {
    $("img").on("contextmenu",function(){
       return false;
    }); 
}); 

```