Defining the middle value of a horizontal scroll bar

No; how could that work?

It's more logical than mathematical.

A scroll bar has integer steps; let's say your step size is 1. And simplify the problem so your min and max are 1 and 5, and you want the middle at 4 instead of 3.

It takes four clicks to get from 1 to 5; which step would be 4? How many clicks from there to 5?

It's not a question of what Excel can do (yet), it's a question of you figuring out (and then explaining) what behavior you want.

You can use formulas or code to transform the scroll bar value in any non-linear way you like.

Yes, perhaps there is a way to write a code for the max and min to get what I want...

OK. Draw a horizontal line on a piece of paper. Put the number 30 on the left end, and the number 44 on the right end. Then intersect the middle of the line with a smaller line. Put the number 36 above this line. 36 represents the middle of my horizontal line.

Obviously 36 is not the logical median for a set of integers between 30 and 44. But that's not what I am looking for. I am looking for a sliding scroll bar between 30 and 44, with 36 at the middle.

In order for this to work, the step size on either side of the middle will not be proportionate. I think if you leave the step size above 36 at 1, the step size below 36 will need to be 6/8. That way, there are a proportionate number of intervals on either side of my middle, but not equal lengths.

So perhaps my real question is this: can excel create slider bars with disproportionate step size on either side of the median?

Does that accurately describe what I'm trying to achieve? Thank you for helping with this question!

A scroll bar has integer values. List a set of (ascending integer) scroll bar values in one column, and the desired results in a second. Use a lookup from one to the other.

Maybe this is what you had in mind?

Row\Col	B	C	D	E	F
2	smin	smax
3	30	44		B3: Input	C3: Input
4	sa	a
5	37	36		B5: Input	C5: Input
6	h	1.2224			C6: =LOG((a-smin)/(smax-smin), (sa-smin)/(smax-smin))
7
8	s	y
9	30	30.00			C9: =((s-smin)/(smax-smin))^h * (smax - smin) + smin
10	31	30.56
11	32	31.30
12	33	32.13
13	34	33.03
14	35	33.98
15	36	34.97
16	37	36.00
17	38	37.06
18	39	38.16
19	40	39.28
20	41	40.43
21	42	41.60
22	43	42.79
23	44	44.00