After DropButton Clicking, it shows all CoboBox’s records with columns visible, but after selecting a record from list, CoboBox shows first column’s value only, rest columns are hidden. Is there a way to show selected record’s all columns?
Thank you in advance
Hello, I use the below code to transfer rows from the "LOG" Tab to the "RTN HISTORY" tab when "SCRAP", or "RELEASED" in Col Z is selected from the drop down. My question is how would I have it transfer back to the LOG tab if "HOLD" is selected from the dropdown? Thanks for all...
Hello Excel Users!
I need some assistance on an array formula for a summary table that will show multiple results for a set of criteria:
Only Leave Types: Call Off, In Late, Leave Early
The first formula I tried with the leave type conditions but it said I was...
I have a very annoying issue that i can;t get my head around, I have a ComboBox change event that refreshes a list as its typed and reduces the options in the drop down list. Works fine
Once I have selected a item from the list, running any other code/macros elsewhere in the document...
I have this is place at present.
Private Sub Worksheet_Activate()
How can it be changed so i also see the 12 rows before it on the page.
I mean sometimes even though cell G13 is selected its could be 1 inch down from the top of the page & i then...
I have a command button that opens up a user form, I would like to add a yes/no message box to the command button and when cell "A4" =01 (01 representing today's date). My message would read"do you want save the data and delete before entering new months data". If yes is...
Currently, my form has a combo box, and it is only showing that in which is selected in the combo box. How can I have it show all items item an item is selected in the combo box? Macro? If so, how would I write that please?
Been tinkering a bit to see if I could get the macro recorded/cobbled together to do the following, and I keep hitting roadblocks in debug:
1.) Select several Sheets, and Ranges in each
2.) Have an Input box pop up, requesting a number
3.) Increasing the selected sheets/ranges by...
I have taken this code from another worksheet & made the edits for it to work on my new sheet.
I type in the search box say AB & all the results with AB are shown in the listbox.
I select the item i require.
My problem is that the item i selected isnt selected on my worksheet in...
I want to select let say 100 cells A1:A100. I can do that using mouse but I wonder of I can select A1 and then go to A100 and they are all selected. I select A1 and I can go to A100 using F5 and type A100 but that would jump to A100 without highlighting the range A1:A100. Thank you.
I have a sheet but in struggling to see if I'm on the correct row when im filling it in
Can you change the row colour when a cell is selected?
ie: if I select any thing between G21:AE21 I can get A21:E21 to change colour
But if nothing is selected then don't change anything
Hello, I have looked around and could not find any VBA that would work for what I am trying to do, which seemed like it should be simpler than it is turning out to be. I want to automatically hide and unhide some rows based on the following:
I have a summary sheet (in "Sheet 1") that summarizes...
I have a table that consists of varying columns, and rows. Its exact format varies with each run, but it will have 2 columns at the end of the table, called "Adjusted Value" and Comments. The number of rows varies.
There are lines in the workbook beyond the bottom of the table that are...
I have one spreadsheet set up with a form detailed within the sheet using VBA and name manager to print data onto the form and save as a pdf. However I took the sheet and created a new one for a different purpose changing the form and all of the names in name manager to match the data...
Long time admirer, first time questioner.
I wonder if anybody knows of a macro which will return the range which has been selected. For example, if I highlight cells B1:E2, the macro will return the value "B1:E2"?
Thanks in advance!