Hi I have a few tables and a few textboxes next to the tables. I want the textboxes to expand when new rows are added to the table.
The range would be dynamic hence I have to find the textbox in the specified range and then adjust the height.
I tried to code it but the height of the textbox...
I have a simple workbook with two sheets.
Sheet 1 contains:
<tbody>
NAME
AGE
HEIGHT
WEIGHT
JOHN
34
52
23
PETER
23
12
62
LUCY
45
23
86
DANIEL
23
42
34
</tbody>
Sheet 2 contains a message: Choose a person
I then has a dropdown/combo box (data validation list, the source being the list...
Good day all
I need help with a MS Word form. I've searched all over the net and followed everything I've seen (I think) and I'm still stuck.
I have a word table that I want people to fill out as a form. but I don't want the person to be able to change the forms layout. Specifically the height...
I have a very simple routine that uses:
ThisWorkbook.Worksheets(proposal).Range("B" & a).EntireRow.RowHeight = 17
to set the row height to 17. When the above line of code executes, it sets the row height to 22 instead of 17.
I have two other identical lines of code that should set the row...
Hi All,
I'm wanting to lookup a value from 2 separate cell values one being height and the other width - to find a match in a pricing matrix. If this can be done at all.
E.g - 717 x 448 = $36.06
<tbody>
<tbody>
Qty
Height
Width
Price EA
Price Total
2
717
448
3
357
405
3
357
405...
Greetings esteemed and learned people of Excel. Please help me with a problem that I thought I could easily handle, by using the max formula.
I need to find the Height, Width and Depth of a series of cabinets.
Each row caters for one cabinet, resulting in only one of the cells to have a value...
Hi great people
I have a work stream spreadsheet that I sort by date, the only thing that I'm.struggling with is the height of the rows based of column A containing the number 1, and then colouring the row (A to M) being dark grey
Can anyone help me?
Hi Everyone,
I have a problem,
I need people to be able to copy and paste text from Word into excel, I have encounted a number of problems doing this as the people doing the cut and pasting are all at the lower end of the gene pool.
So after many hours of testing the only solution I could find...
Hi all - whenever I used AutoFit Row Height on a row that is referencing data from another sheet(Lets say, Im on Sheet1 and Cell A1 is referencing Sheet2!A7), the row height does not expand to fit all of the text. Is there a simple way to get this to work? Obviously there is no problem when...
I have a spreadsheet w/ vba coding to format the sheet via command button. It will autofit the row height, but when printing it cuts off the of some of the cells that contain a lot of wording. Is there a way to have it autofit and also add 5 more to the height via vba?
Hello,
in a workbook it is possible to adjust the height of the rows only if clicked
in the cells of column C / F / G not selecting the whole row?
I hope I explained myself
john
Is it possible to increase the height of a active x control text box as you type in it. This would mean that it appears to expand downwards. I tried the auto size feature but this just shrunk the text to squeeze it all in when you deselect the text box.Is it possible to make it just stay...
I have two columns one with heights (i.e. 6'6", 6'7" etc) and one with weights say column I and J. In another cell C2 I would like to be able to enter a height, while still displaying height, yet for a calculation use the corresponding weight.
Is there a way to get a row to resize if it is below acertain height?
I have my rows in a range set to 38 but I have them autofitting once the day is entered in case the row needs to be taller.
Is there a way for this to either only resize if it is goingto make it taller OR after the AUTOFIT...
I have a small issue with a particular workbook that is driving me insane.
The workbook contains a log of personal transactions over the past couple of years. Every other time that I use it, the row height for a set of 3 rows is increased to the maximum.
The set of rows changes each time, and...
is there a way to set a set cells/rows to change the row height based on how much is typed into that cell?
If the user types too much it will make the cell height higher instead of shrinking the text.
I know there is some way because I have another worksheet that does this but I do no know how...
Hi Guys,
I'd like to change the line spacing between items in a VBA listbox. Let's assume I display month names in a listbox control. Name of my listbox is "Lista". It's easy, I just add one line to "Private Sub UserForm_Initialize" for the userform:
Lista.List = Array("January", "February"...
Need help with the following:
I have a height and width column in pixel count. I convert the pixels to inches without a problem.
How do I figure out the last row in the column. They amount of rows will change every time I pull my data. In other words, how can I create my calculation for each...
Hi all,
I can't wrap my head around this. I have a userform that will resize frames and listboxes based on the number files in the folder. However the resize doesn't work unless I input either 'DoEvents' or 'Wait' into the code.
The code is in the form and not in a separate module.
Private...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.