-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
vba excel
-
K
check for a value in a range
Requires a VBA program that performs following functions: Just to tell you series of steps to make it clear 1.Two combo boxes with first one having values of classes that is "One", "Two" and "Three". the second one having values - "GoodCs", Goodb" and "Attentive". 2.Now suppose i select "One"...- khur_chesk
- Thread
- vba excel
- Replies: 0
- Forum: Excel Questions
-
K
Ensuring no duplicates in listbox
i have a listbox which adds items with a button, every time i click it again adds up those same items which i dont want . can there be any solution for this in VBA?- khur_chesk
- Thread
- vba excel
- Replies: 1
- Forum: Excel Questions
-
W
VBA Code to Include new Worksheets
My company works on jobs with multiple stages and we have to bid each stage seperatly and then total up all of the stages. We are trying to simplyfy this experience for our sales team using VBA and macros. I have a macro recorded in an estimate writing workbook that copies the revenue...- wootenka
- Thread
- excel macro vba excel
- Replies: 1
- Forum: Excel Questions
-
R
VBA Excel Arrow up to next visible cell or offset up
Folks: How do I "ActiveCell.End(xlUp).Select" without the "End" or ActiveCell.Offset(-1, 0).Select to the next visible cell? I know "ActiveCell.End(xlUp).Select" gets me to the next populated cell or end of contiguous data and ActiveCell.Offset(-1, 0).Select gets me to the cell right above my...- Rowland Hamilton
- Thread
- arrow keys grouped rows offset vba excel visible cells
- Replies: 3
- Forum: Excel Questions
-
G
Substantial modification of a table - EXCEL 2007
Hi, I have substantial amount of information which I would like to arrange in the following manner. I did believed I was an 'ok' Excel user, but I have tried this problem with PIVOT tables, with concatenation of IF / HLOOKUP, with very limited success. (and more gray hair) The way I have it...- gseri
- Thread
- data tables vba excel
- Replies: 2
- Forum: Excel Questions
-
A
VBA Excel: Advanced search
I'm new to VBA so I'm not sure how to do this.... Any help is appreciated...... Problem is the following: Passing trough one fixed column ("B") I need to find out how many (summarized) occurrences of LEFT(String, 2) there are. Problem is the condition, because it's based on 60 cases - if...- amarty
- Thread
- vba excel
- Replies: 10
- Forum: Excel Questions
-
E
Change Pattern on Selected Rows Inside a Named Range
I have a particular problem with some code I'm hoping someone more familiar with Range and/or Offsets can help me with. I have a multi-sheet workbook with named ranges defined on most of the sheets. What I want to do is search the first column of each named range and if a matching code is read...- Eldrod
- Thread
- interior pattern range vba excel
- Replies: 2
- Forum: Excel Questions
-
E
IF Statement Parsing
Anyone have any code that can be used to parse an IF statement read from a cell into its 3 parts (condition test, true case, false case)? I'm not really wanting to have to write that from scratch. Any help is greatly appreciated!- Eldrod
- Thread
- if statement parse vba excel
- Replies: 3
- Forum: Excel Questions
-
T
Find Text & Replace Adjacent Cell's Formula
Hey all! I'm looking for a code I can run in VBA that can look through a worksheet for a specific word and, if found, replace the formulas for the 3 cells immediately to the left of it. For Example: I want it to look through column I:I and everytime it sees the word "Total" I want it to...- Trikageon
- Thread
- find & replace vba excel
- Replies: 19
- Forum: Excel Questions
-
P
VBA conditional formatting (Excel 2003)
I've searched and seached, and haven't found the solution I'm looking for. I have 5 conditions, and as you know Excel only allows 3 conditional formats. I have little VBA experience, so I can't seem to create this on my own. I'm trying to fill the color of a cell based on the value in...- PTD
- Thread
- conditional fomratting vba excel
- Replies: 13
- Forum: Excel Questions
-
A
Simple Copy value question
I simply want to assign the value in one range to another range. Let’s say I have Worksheet1, which has a cell named Range1 containing the value “AAA”. I have another sheet, Worksheet2, with a cell named Range2. I want to assign the value in Range1 to cell Range2. Shouldn’t I be able to say…...- AAAAndy
- Thread
- vba excel
- Replies: 2
- Forum: Excel Questions
-
VBA Code Needed to Reorganize Dated Columnar Data to Sequenced Row Data
Raw data is Comma Delimited text file organized Column-wise. For each daily date (oldest to newest), there are various weather data in adjacent Columns. I am only interested in two Columns of data ... the MAX & MIN Temp for each day. I need to process the data and reorganize it Row-wise. One...- powerjak
- Thread
- converting data rearrange transpose macro vba excel
- Replies: 0
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Launch Script When Tab Is Opened
- Started by ExcelAtEverything
- Replies: 69
Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when... -
VBA that can extract words that starts with # and ends with 2021.
- Started by whyjaydee
- Replies: 26
Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no... -
Date update overflow error ‘6’
- Started by Tayl4n
- Replies: 31
Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date... -
VLOOKUP Formula ?
- Started by zone709
- Replies: 23
Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried... -
conditional formatting the whole row
- Started by RAJESH1960
- Replies: 23
Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some... -
Vlookup in vba
- Started by CamVilla
- Replies: 21
Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...
We've detected that you are using an adblocker.
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.
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".
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.
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.
1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back