Select Case Macro (Function)

[nguyenak]

Hello,

I need the following as a macro function.

If ColumnA= "Domain1",
then ColumnC = "english/" & ColumnB (whichever cell is next to the active cell)


I would like to use a Select Case Macro for this:
Case Domain1
english/Page

Case Domain2
french/Page2

Table
Column A Column B Column C
Domain1 Page
Domain 1 Page1
Domain 2 Page2


Final Table (Goal)
Column A Column B Column C
Domain1 Page english/Page
Domain 1 Page1 english/Page1
Domain 2 Page2 french/Page2

[HaHoBe]

Hi, nguyenak,

I´d go with a formula instead of VBA. Code goes behind the worksheet where it´s to be used (right-click on the worksheet tab, View Code):

Please Login or Register  to view this content.

This will only help with new entries.

Ciao,
Holger

[nguyenak]

Hi HaHoBe,

Im new to VBA so Im sorry for not following your instructions. I've attached the file with your code included. What do I do next?

thanks again for your help

[HaHoBe]

Hi, nguyenak,

like stated above teh event will only fiore for new entries (or if you alter the entries). If you want the existing rows to be amended you would need something like the following whoich would go into a normal module:

Please Login or Register  to view this content.

To run the code use ALT+F8 to choose from the list of available macros.

Ciao,
Holger

[nguyenak]

works perfect...thank you so much.

thanks again!