YTL Excel #118: Form Controls Linked To Cells

[fokozuynen]

when i want to print the file is apear those arrows , what can i do to by without?

[valenta79]

Hi there,

I have a dillema. I am using form controls in my worksheet. I have an option to change hotel numbers from sales to room nights. Everything calculates fine but I have one issue. Dollar sign does not change for room nights, basically i can choose to have one way or another but once data populates number format does not change. I want my sales numbers to have $ sign but room night numbers to be without it. I am using conditional formatting but no success. let me know if you can help!!

[ExcelIsFun]

You probaly need VBA for that. I am not good with VBA. You can post a question to this site:

mrexcel[dot]com/forum

[Mynotoar]

Really awesome :). That's very useful!

[ExcelIsFun]

I am glad that you liked it!

[izhak007]

Your work is great!!

I really enjoy it !

thank you

[izhak007]

Thank you

I had ‏‎to use only one ‏‎quotation marks and not two in order to make it work

That how I wrote it

Range("a1").Value = sbp / 100

[ExcelIsFun]

Dear izhak007,

Great! Watch for a video on this topic (with a few methods) in about 2 weeks.

--excelisfun

[ExcelIsFun]

Dear izhak007,

I will post a video on this topic at the end of the week.

--excelisfun

[izhak007]

Can I ‏‎design a form scroll control ‏‎button target cell as percentage ‏ 39% for ‏‎example.

itzik

[ExcelIsFun]

Dear izhak007,

Try this to add VBA Scroll Car:

1. Add ActiveX Control Scroll Bar

2.Right-click SB, Properties

3.Max = 100

4.Min = 0

5.SmallChange = 1

6.(Name) = SBPercent

7.Right-click SB, View Code

Next comment:

[ExcelIsFun]

Remaining instructions:

8.Type VBA code:

Private Sub SBPercent_Change()

Range(""A1"").Value = SBPercent / 100

End Sub

9.Close VBA editor

10.Get out of Design Mode

11. Try Scroll Bar

--excelisfun

[PrincessWithSkills]

Awesome!

[ExcelIsFun]

Dear PrincessWithSkills,

Cool! I am glad that you liked it!

--excelisfun

[ExcelIsFun]

Dear fer1403,

Bonito Truco = Tuna Trick.

--ExcelIsFun

[fer1403]

Bonito Truco