If you're totally new to Excel Macros & VBA... get my FREE e-book at this link: DOWNLOAD EBOOK → www.launchexcel.com/record-your-first-macro-ebook-now Leave comments with any questions you have... And click on the LIKE button if you found this video helpful. Thanks for supporting my channel!
@abdulcadersalem8794
4 жыл бұрын
What about changing column width instantly base on value sir.. thanks
@edayers315
6 жыл бұрын
Very nice! I used this but used other functions to get variable height of cells like (LEN) IF and Max to get the cell in a row that requires the most height. Thank you
@elderbarboza5595
2 күн бұрын
How can use this code with worksheet calculate()?
@amnahussain1457
Жыл бұрын
Hi, this video is very useful, unfortunately I am getting "Compile error, Expected list Separator or )"
@stuartgalley9237
5 жыл бұрын
Hi, I am new to Visual Basic and understand the basics of this tutorial however should i wish to determine the row height from a piece of text in a drop down list, for example one choice being "Basic" and the other being "Advanced" how do i assign the row height value of 0 to basic and 14.4 to Advanced.
@jaminnetwork
4 жыл бұрын
You could hard code this into VBA by using a Worksheet Change Event and a routine that specifically checks for a change to a specific cell (in this case, the cell with the two data validation options; ‘Basic’, ‘Advanced’). This can be achieved with an ‘If Not Intersect(Target, Range(“”)) Is Nothing Then’. You could use an if statement or a select case statement within this to adjust row height based on the cell value and the corresponding, pre-defined row height for that particular value. If you wanted this to be more dynamic you could incorporate a table that comprises of the text string and the corresponding row height that you want to use for that value and reference/lookup this.
@danstewart4796
6 ай бұрын
This is very helpful and was wondering if you could expandit a little further to have different row heights for a number of rows? I have an application where I would need to control the row heights of 10-15 rows with varying heights. Is this possible?
@launchexcel
6 ай бұрын
Hi Dan, yes you can expand the functionality by adding new lines in the Select Case statement (9:10) Select Case [variable] Case [condition 1] [Statement 1] Case [condition 2] [Statement 2] Case [condition n] [Statement n] Case Else [Statement else] End Select You can choose different cells as your condition in each "Case" line. And the code after each "Case" line will control which row height you want to change.
@elderbarboza5595
9 күн бұрын
It will able to efficient use this in twenty five sheets varying heights. ¿You can do one example please?
Пікірлер: 14