form controlls - combo box cell link returns ralative position instead of cell value

Diskutiere form controlls - combo box cell link returns ralative position instead of cell value im Office Forum im Bereich Microsoft Community Fragen; So for example, I have created a list of 12 months January to December (vertical list in different sheet) and I select 01.10.17. The linked cell...
  • form controlls - combo box cell link returns ralative position instead of cell value Beitrag #1
M

MSCom

Neuer Benutzer
Threadstarter
Dabei seit
20.09.2016
Beiträge
1
So for example, I have created a list of 12 months January to December (vertical list in different sheet) and I select 01.10.17. The linked cell will not show the selected date (01.10.17) but instead it will return 10 (because October is the 10th entry in my list. Because of the way excel numbers the days internally it will therefore convert this into 10.01.1900 instead of the selected 01.10.2017.

Does anyone know, how I get Excel to show the selected value instead of its relative position? I am kinda new to the VBA world, so my apologies in case this is clear to everyone else.



here is how I configured the form controll
FileDownloadHandler.ashx
 
Thema:

form controlls - combo box cell link returns ralative position instead of cell value

form controlls - combo box cell link returns ralative position instead of cell value - Ähnliche Themen

How to condition formula on other cell content: Hi, I am not sure how else to phrase my request and hope someone can help me. I created an expense list for my project and am constantly...
Using Vlookup on other Workbook whichs path is stored in a Cell: Good Day Im Trying to do Vlookup on a closed Workbook whichs path is stored in a Cell. For that im writing a Function which opens the Workbook...
MS Flow - Sharepoint HTTP Request change person field value: Hello, I need to change the person field value with my Flow. The problem is that I can't just pass the string in the json, they want something...
automatically switch to the next cell after the type-in of only one digit without entering - possibl: Dear Excel-Community, for a fast Sudoku type-in of the given numbers into excel (to solve it with AIMMS), I would like to know whether it is...
Counting Records in Recordset with Condition: I have a large table of dates and I am using an audit table to track the changes. Conditional formatting lets me highlight fields in my forms that...
Oben