YTL Excel #118: Form Controls Linked To Cells
Loading...
Loading...
20,842
Link to this comment:
Share to:
Uploader Comments (ExcelIsFun)
see all
All Comments (9)
-
when i want to print the file is apear those arrows , what can i do to by without?
-
Your work is great!!
I really enjoy it !
thank you
-
Dear izhak007,
Great! Watch for a video on this topic (with a few methods) in about 2 weeks.
--excelisfun
Loading...
- 8:02How to Add a Combo Box Control to an Excel Invo...by DannyRocksExcels14,439 views
Featured Video
- 8:05Mr Excel & excelisfun Trick 96: LOOKUP Function...by ExcelIsFun568 views
- 6:35Excel Magic Trick 862: Count Numbers In Column,...by ExcelIsFun1,651 views
- 7:31Mr Excel & Excelisfun Trick 95: Conditionally F...by ExcelIsFun1,314 views
- 10:23Excel Magic Trick 861: Conditional Format 50 Co...by ExcelIsFun1,604 views
- 7:01Excel: Drop-Downs(Combo Box) and Conditional Fo...by iProRyan29,193 views
- 6:45Linking Data from Different Excel Sheets and Wo...by ExcelFormulas14,035 views
- 5:32How to Add Scroll Bars Controls to an Excel Formby DannyRocksExcels4,754 views
- 8:02Excel Magic Trick #111: Build A Questionnaireby ExcelIsFun24,369 views
- 1:40Excel 2007 - Create Basic Inventory System usin...by jiejenn70,748 views
- 9:42Excel 2003: formularios vba control "checkbox" ...by profeantoniorodrigo16,272 views
- 1:35Excel VBA Userformby Dandandidi4you59,359 views
- 10:10activeX with Excel 2007by stikpet9,295 views
- 10:15How to Add a Check Box Control to an Excel Formby DannyRocksExcels27,071 views
- 10:44VBA LESSON 8 - FORMS - See more at ExcelVBASql....by ExcelVBAHelp17,038 views
- 4:45YouTube - Microsoft Excel Training- Checkbox fo...by davidlee19711,038 views
- 9:57Introduction to Writing GUIs in Excelby jakeblanchard94,881 views
- 6:59Using Controls in Excel spreadsheetsby RichardJohnPhillips2,655 views
- 7:00i-teach-u Excel 2nd look at Option Buttonsby JackBarnett2114,320 views
- 2:31Excel Tutorial - Create a Dynamic ComboBox Filterby akphidelt42,787 views
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!!
valenta79 1 year ago
You probaly need VBA for that. I am not good with VBA. You can post a question to this site:
mrexcel[dot]com/forum
ExcelIsFun 1 year ago
Really awesome :). That's very useful!
Mynotoar 2 years ago
I am glad that you liked it!
ExcelIsFun 2 years ago
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
izhak007 2 years ago
Dear izhak007,
I will post a video on this topic at the end of the week.
--excelisfun
ExcelIsFun 2 years ago